File to close itself and the current instance of XL
 

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.

File to close itself and the current instance of XL
 

'quit without any question
application.displayalerts=false
application.quit


"XP" wrote:

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.

File to close itself and the current instance of XL
 

Thanks, but this doesn't work. The file closes and leaves the Application up.


"Vergel Adriano" wrote:

'quit without any question
application.displayalerts=false
application.quit


"XP" wrote:

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.

File to close itself and the current instance of XL
 

Instead of closing the workbook:

ThisWorkbook.Saved = True
Application.Quit

The workbook will close when the application quits.

"XP" wrote:

Thanks, but this doesn't work. The file closes and leaves the Application up.


"Vergel Adriano" wrote:

'quit without any question
application.displayalerts=false
application.quit


"XP" wrote:

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.