Out Of Memory Errors

pakman · January 27th, 2005, 06:10 AM

I have some VBA code which continuously polls a directory looking for new files. It then opens the files & performs calculations based on their contents. The problem I am having is that after the program runs for a few hours I then get "Out Of Memory" errors. Any advice?

mjppaba · January 27th, 2005, 08:44 AM

Have a look at this article in MSDN..

http://support.microsoft.com/default...b;en-us;248180

Tell us if this resolves your problem.

cheers

Matthew

pakman · February 5th, 2005, 05:56 AM

Left the program running for a week now & no errors!

Thanks