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