VB5 application not releasing instance of Excel 97 when exporting or importing

  • Thread starter Thread starter Christine
  • Start date Start date
C

Christine

I am encountering a problem whenever I am importing or
exporting data to or from EXCEL 97 from Visual Basic 5
(via VBA code), especially when it involves more than 1000
records; it does not release the EXCEL instance from the
task manager. I don't see the EXCEL instance if there are
fewer records. How should I fix this problem? It is
causing the application to hang.

Please help!

Thanks.
 
Christine said:
I am encountering a problem whenever I am importing or
exporting data to or from EXCEL 97 from Visual Basic 5
(via VBA code), especially when it involves more than 1000
records; it does not release the EXCEL instance from the
task manager. I don't see the EXCEL instance if there are
fewer records. How should I fix this problem? It is
causing the application to hang.

Please help!

Thanks.
Click to expand...

Repost to microsoft.public.excel.programming for more expertise.

Q
 
Back
Top