View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kent Prokopy[_3_] Kent Prokopy[_3_] is offline
external usenet poster
 
Posts: 9
Default 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