VBA, what is the command to EXIT the EXCEL PROGRAM!

[Guest_imported]

In my automatic macro, i want to exit the excel program automatically. what is the command to do this in vba?

Thank You

 

[JrClown]

Try this:

Sub Macro1()
ActiveWorkbook.RunAutoMacros Which:=xlAutoClose
End Sub QUOTE OF THE DAY
I will prepare, and some day my chance will come.
Abraham Lincoln

<%
Jr_Clown )
%>

 

[Guest_imported]

Well, what i meant was to exit the EXCEL.exe program not a macro.

What command would you use to do this?

 

[dsi]

To close the Excel application from a macro:

Application.DisplayAlerts = False
Application.Quit

 

[Guest_imported]

THANK YOU !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

 

[badrion]

I want to run a macro on save. The macro needs to check all cells that are 'numeric' and either change the format to 'general' or put a 'tick in front of the numeric expression.

The reasoning behind this is I use this file in a VB application, it opens the file, queries out the data I need and creates a text file, but when the user changes something in the excel file it resets my format. If anyone has a better idea of how to do this, I'm open for opinions.

Thanx,
Brandi

 

[badrion]

sorry, i put this in the wrong spot.....