Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 36
Default closing file without saving

Thank you both
I didn't think it would bee that simple

"Novice Lee" wrote:

How can I close a file without saving the file automatically.
I use the following code for closing the file:
Windows("MasterData - 2009.XLS").Activate
ActiveWindow.Close

is any thing I can add to it or change so I don't get the "Do you want to
say" box? I never want to save the file.

Thanks

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
closing file without saving Dave Peterson Excel Programming 0 April 17th 09 02:55 PM
auto saving & closing file prtcorvette Excel Worksheet Functions 1 May 21st 08 10:06 PM
How to code on Macro on saving and closing a file? Eric Excel Worksheet Functions 1 June 10th 07 01:32 PM
skipping pop up box for saving changes when closing a file Tony Excel Programming 1 October 1st 04 07:49 PM
closing a file without saving matt dunbar Excel Programming 3 November 25th 03 06:29 PM


All times are GMT +1. The time now is 12:44 PM.

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"