My program uses up resources

[Dom Olivastro]

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

 

[E_R]

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