K
Kevin.Lynch
I wanted to share some info in order to help others who may have been
experiencing similar problems. I had some VBA code that utilized the
Application.Quit method. This line of code seemed to be ignored unless
I manually stepped (F8) through the code. After many hours of google
searches,I noticed that others were having trouble with instances of
excel remaining in memory after this methd was called. This was NOT my
problem. I could not even get the Application to visually close. As
as test I created these subs in a new worbook.
Private Sub Workbook_Open()
Call Test
End Sub
Sub Test
Application.Quit
End Sub
As simple as it gets yet still the application would not quit.
It turns out, that my problems relate to a Showcase Query Add-In that
is loaded when Excel is launched. This Add-In is somehow interfering
with the Application.Quit Method. When I Remove the Showcase Query
Add-In, the code runs fine.
experiencing similar problems. I had some VBA code that utilized the
Application.Quit method. This line of code seemed to be ignored unless
I manually stepped (F8) through the code. After many hours of google
searches,I noticed that others were having trouble with instances of
excel remaining in memory after this methd was called. This was NOT my
problem. I could not even get the Application to visually close. As
as test I created these subs in a new worbook.
Private Sub Workbook_Open()
Call Test
End Sub
Sub Test
Application.Quit
End Sub
As simple as it gets yet still the application would not quit.
It turns out, that my problems relate to a Showcase Query Add-In that
is loaded when Excel is launched. This Add-In is somehow interfering
with the Application.Quit Method. When I Remove the Showcase Query
Add-In, the code runs fine.