Excel Application.Quit problem

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top