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.
 
Instead of closing the workbook:

ThisWorkbook.Saved = True
Application.Quit

The workbook will close when the application quits.
 
Back
Top