View Single Post
  #25   Report Post  
Posted to microsoft.public.excel.programming
Brouws Brouws is offline
external usenet poster
 
Posts: 2
Default Opening/Closing Large Files

Nigel,

You may have to add an "erase dataWb" statement inside the for/next
loop. I believe objects may not be overwritten when you re-set them,
which may still cause a memory leak, even though you may not actually
be running out of memory.

Good luck,