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

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.

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

Thank you