Close workbook/excel
 

How can I close excel using a macro ?

Close workbook/excel
 

Application.Close

Bob Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Mike" wrote in message
...
How can I close excel using a macro ?

Close workbook/excel
 

i think that's a typo
s/b application.QUIT

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Bob Flanagan wrote :

Application.Close

Bob Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Mike" wrote in message
...
How can I close excel using a macro ?

Close workbook/excel
 

if workbooks are open, and you don't want Excel prompt to save them then use

Application.DisplayAlerts = False
Application.Quit

"keepITcool" wrote:

i think that's a typo
s/b application.QUIT

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Bob Flanagan wrote :

Application.Close

Bob Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Mike" wrote in message
...
How can I close excel using a macro ?