VB5 Excel component hangs when processing large amounts of data

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

Thanks for any help!
 
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
 
Back
Top