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

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.
 
Q

Quaoar

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VB5 Excel component hangs when processing large amounts of data 1
Add additional header or data into excel after exporting - asp.net application 2
Saving Excel format from web based application 1
Importing Excel Worksheet 2
Advanced issue; second instance of Excel will not go away! 4
Enum not usable in Excel 97? 2
Importing or Exporting "other Contacts" into Word or Excel 2
Using An Already-Open Instance of Excel 1

Top