Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,101
Default Close workbook/excel

How can I close excel using a macro ?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 340
Default 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 ?



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,253
Default 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 ?

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,298
Default 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 ?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
exiting excel ONLY the workbook will close Brandon Excel Discussion (Misc queries) 12 May 27th 10 09:59 PM
Close Workbook in Excel Brenda from Michigan[_2_] Excel Discussion (Misc queries) 3 February 6th 09 06:32 PM
generic macro on close of excel workbook Anniebella Excel Programming 2 April 6th 05 07:43 AM
Excel workbook will not close due to VB Reference link Ricardo Excel Programming 2 January 26th 05 05:28 PM
How do I? Get Excel to do something when I close a workbook emu_tails Excel Programming 2 October 12th 03 08:04 PM


All times are GMT +1. The time now is 06:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"