Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tracking Virtual Memory
roch1009 wrote:
I have an application written with Excel's VBA that performs batch process on files using external programs. Often the program eventually errors due to a depletion of virtual memory (which can be restored if I closed and re-open the external program). How can I track virtual memory using VBA, so that I can close and reopen the program when the memory gets low? Thanks, Jeff Well, Excel *is* notorious for leaking memory, and it has not gotten any better with any revision or update since Excel 1.0 I used on a Macintosh. The problem is prevalent in just the type of repetetive file operations that you are doing, and I have never seen a posted definitive solution. Having responded with this answer, maybe you and I will get lucky. Q |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with PowerPivot Virtual Lab | Excel Discussion (Misc queries) | |||
XL 2007 - Out of Memory - memory leak/bug? | Excel Discussion (Misc queries) | |||
Virtual Clock | Excel Worksheet Functions | |||
Virtual PC | Setting up and Configuration of Excel | |||
Tracking Virtual Memory (bump) | Excel Programming |