Wrox Programmer Forums
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 8th, 2007, 11:08 AM
Registered User
 
Join Date: Oct 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Writing to RAM

I am writing a file 3 times a second to a hard drive and then deleting it after a set a mount of time (15-20 seconds), this a a lot of work for the hard drive IMO. I was wanting to know if there was a way to write to ram and then if I want to keep these files write them to the HD. Thanks in advance,
Nick

 
Old October 10th, 2007, 08:56 AM
Friend of Wrox
 
Join Date: Feb 2007
Posts: 163
Thanks: 0
Thanked 2 Times in 2 Posts
Default

There is a need to save the workbook before processing is done? Not sure I understand why it would be necessary.

If you have enough memory then the best solution would be to create a RAM Drive to save the file to initially. Then you can move the file from the RAM Drive to your hard drive. Then Excel could close or crash but as long as you haven't powered down you still have the file 'stored' there. The problem is that the file isn't really saved and will be lost at power down if it hasn't been moved or saved to the hard drive.

Another possibility for keeping 'old' values in case you wish to restore them is to load them into a global array so the values are available if needed. This wouldn't work if you actually need to close Excel at times for any reason before accessing the stored values again.

 
Old October 10th, 2007, 02:01 PM
Registered User
 
Join Date: Oct 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Creating a RAM drive would be great, however I am unsure how this is done.

Thank you







Similar Threads
Thread Thread Starter Forum Replies Last Post
Writing to Database Scripts82 ASP.NET 1.0 and 1.1 Professional 8 September 15th, 2006 07:47 AM
Files needed to run ASP.NET? RAM req'd? Ron Howerton ADO.NET 1 February 15th, 2005 09:08 AM
Java IDE's that run with 128 MB RAM. coolmaniac Java GUI 3 August 8th, 2004 05:08 PM
writing to a database charliejamesuk MySQL 1 March 25th, 2004 11:10 AM
Insufficiant RAM memory chacquard Access 1 February 9th, 2004 01:06 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.