I have a VB6 program that uses Excel 9.0 object model. It
looks like this

set x = Excel.Application
for i = 1 to 500
set b = x.workbooks.open (...)
set s = b.worksheets(...)
[Process "s"]
call b.Close
next i
call x.quit

This causes my PC to freeze with the message "Resources
are dangerously low" (or something like that). I figured
Excel leaves garbage behind when a book is opened and
closed, so I did this:

for i = 1 to 500
set x = Excel.Application
set b = x.workbooks.open (...)
set s = b.worksheets(...)
[Process "s"]
call b.Close
call x.Quit
Next i

I assumed that closing Excel after each book would force
the OS (Win 98) to clean up the garbage, but the computer
freezes.

Any ideas?

Dom

There is some clean up you have to do...

set x = nothing
set b = nothing
set s = nothing

...but this will not improve the speed or efficiency. I just ra
through your second block of code and it seems reasonable enough to do
however, I have no clue what process "s" is, which is where I suspec
your problem lies. Try commenting out the call to process "s" to see i
that is where the problem is

--
Message posted from http://www.ExcelForum.com