I am having problems with Excel.exe floating in my Sys Tray.
How can I solve this. It seems like when I run the following code below, somtimes Excel.exe will close out in sys tray, and sometime it will not, causing to get multiple instances of Excel.exe which causes strange things.
What is causing this inconsistency?
Does anyone have any suggestions?
Thanks, Aaron
Dim XlApp As Object
Dim XlObj As New Excel.Application
Set XlApp = XlObj.Workbooks.Open(ExpFilePath & FileName, 0)
XlObj.Visible = True
XlObj.DisplayAlerts = False
XlObj.Quit
Set XlObj = Nothing
How can I solve this. It seems like when I run the following code below, somtimes Excel.exe will close out in sys tray, and sometime it will not, causing to get multiple instances of Excel.exe which causes strange things.
What is causing this inconsistency?
Does anyone have any suggestions?
Thanks, Aaron
Dim XlApp As Object
Dim XlObj As New Excel.Application
Set XlApp = XlObj.Workbooks.Open(ExpFilePath & FileName, 0)
XlObj.Visible = True
XlObj.DisplayAlerts = False
XlObj.Quit
Set XlObj = Nothing