Excel 2000 and Memory
 

I have an add-in I wrote, (One of many)
For a simple breakdown, The add-in opens excel files, updates them via ADO
2.7. Closes and saves the files.

This add-in updates 200 workbooks. The problem I am having is that it is
running out of memory about half way through.
I am seeing something strange that may be someone else has seen and can give
me some advise on.
After the add-in opens, updates and closes the workbook. The workbook is
still listed in the VBAProject window.

Thank you in advance for any thoughts and or help.
Kent Prokopy