File to close itself and the current instance of XL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using Office 2003 and Windows XP.

I have an Excel file that is designed to open, run some code and then close
itself and the current instance of the application that was started when the
file was opened.

Could someone please save my life and post some generic example VBA
illustrating how to do this or, better yet, modify my existing code below?
(If possible, I need this rather soon...)

My current code closes the file, but not the Application:

Dim oThisWorkBook As Workbook
<Other code>
oThisWorkBook.Close SaveChanges:=False

Thanks much in advance for your much needed assistance.
 
'quit without any question
application.displayalerts=false
application.quit
 
Thanks, but this doesn't work. The file closes and leaves the Application up.
 
Instead of closing the workbook:

ThisWorkbook.Saved = True
Application.Quit

The workbook will close when the application quits.
 

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

Back
Top