PearlGI
Registered User.
- Local time
- Today, 00:41
- Joined
- Aug 30, 2001
- Messages
- 125
I've got a database that creates an Excel object, outputs data, formats and then saves the Excel file. Excel then closes.
The problem is the Excel object hasn't been fully closed as it still appears within the NT Task Manager process list. This causes the code to crash if it's then run a second time.
Below is an extract of the code used to create and close the object. What needs changing to fully close the object.
Public objExcel As Object
Set objExcel = CreateObject("Excel.Application")
{processes}
objExcel.Quit
Set objExcel = Nothing
Any help gratefully received.
The problem is the Excel object hasn't been fully closed as it still appears within the NT Task Manager process list. This causes the code to crash if it's then run a second time.
Below is an extract of the code used to create and close the object. What needs changing to fully close the object.
Public objExcel As Object
Set objExcel = CreateObject("Excel.Application")
{processes}
objExcel.Quit
Set objExcel = Nothing
Any help gratefully received.