A
Amjad
I have a program that updates an Excel sheet everytime
the user presses a button. However, each time it creates
a new instance of the Excel.exe application running in
the background.
I tried closing my Excel object (oExcel) using the
following:
oExcel = Nothing
oExcel.quit()
Yet, I still can see an instance of Excel.exe in the
Windows Task Manager Processes.
Any idea on how to force this application to terminate
once I'm done with it?
Note1: I define the Excel object using:
Dim oExcel As Excel.Application
oExcel = CType(CreateObject("Excel.Application"), _
Excel.Application)
Note2: When I end my program, that instance of Excel
disappears. I wish to see that without leaving my program.
the user presses a button. However, each time it creates
a new instance of the Excel.exe application running in
the background.
I tried closing my Excel object (oExcel) using the
following:
oExcel = Nothing
oExcel.quit()
Yet, I still can see an instance of Excel.exe in the
Windows Task Manager Processes.
Any idea on how to force this application to terminate
once I'm done with it?
Note1: I define the Excel object using:
Dim oExcel As Excel.Application
oExcel = CType(CreateObject("Excel.Application"), _
Excel.Application)
Note2: When I end my program, that instance of Excel
disappears. I wish to see that without leaving my program.