File to close itself and the current instance of XL

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.
 
G

Guest

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

Top