#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 271
Default close code

I need a code that will close the active workbook and save it without giving
you any of the pop-up boxes that autimatically "pop-up" asking you if you
want to save etc.


--
Thanks
Shawn
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default close code

Activeworkbook.Close SaveChanges:=True

--
Regards,
Tom Ogilvy

"Shawn" wrote in message
...
I need a code that will close the active workbook and save it without

giving
you any of the pop-up boxes that autimatically "pop-up" asking you if you
want to save etc.


--
Thanks
Shawn



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
close form code tkaplan Excel Discussion (Misc queries) 1 June 3rd 05 10:49 PM
Code to close workbook Mason Excel Programming 10 March 29th 05 08:58 AM
Close VB in Code Paul Watkins[_2_] Excel Programming 2 December 17th 03 09:25 PM
VBA code to automatically close file Kevin Excel Programming 4 November 6th 03 04:18 PM
Close worksheet with Macro or Code sanaullah Excel Programming 1 October 2nd 03 08:35 PM


All times are GMT +1. The time now is 02:22 PM.

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

About Us

"It's about Microsoft Excel"