VB5 Excel component hangs when processing large amounts of data

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.

Thanks for any help!
 
S

smalltalk_vb

Make sure you use the Quit method and set the object to
nothing when you finsh running the procedure.

....
objExcel.Quit
Set ObjExcel = Nothing
End Sub
 

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 application not releasing instance of Excel 97 when exporting or importing 1
PExcel AddIn hangs when trying to access data programatically 1
Formatting and data loss when migrating from Excel 2003 to 2007 2
Delete Rows of Data in multiple Excel Sheets upon importing to Access 1
Excel Hangs when working with a large list 1
Problems copying Large Amounts of Data in Excel 2007 1
Problems designing combo boxes in forms in Excel 2003 9
Excel COM application hangs on Workbooks.Open 1

Top