| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
closing without saving within a macro
I am trying to close a spreadsheet without saving any changes to it from within a macro, but at the moment it keeps asking me do I want to save changes. The code so far is Windows("control of contract - item 1.xls").Activate ActiveWorkbook.Close Can someone help. I don't want to save before closing which would get rid of the message because it takes about 10 seconds to close. Thanks for any replies Okanem -- okanem ------------------------------------------------------------------------ okanem's Profile: http://www.excelforum.com/member.php...fo&userid=9301 View this thread: http://www.excelforum.com/showthread...hreadid=320054 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
closing without saving within a macro
Hi
use application.displayalerts=false ActiveWorkbook.Close -- Regards Frank Kabel Frankfurt, Germany "okanem" schrieb im Newsbeitrag ... I am trying to close a spreadsheet without saving any changes to it from within a macro, but at the moment it keeps asking me do I want to save changes. The code so far is Windows("control of contract - item 1.xls").Activate ActiveWorkbook.Close Can someone help. I don't want to save before closing which would get rid of the message because it takes about 10 seconds to close. Thanks for any replies Okanem -- okanem --------------------------------------------------------------------- --- okanem's Profile: http://www.excelforum.com/member.php...fo&userid=9301 View this thread: http://www.excelforum.com/showthread...hreadid=320054 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
closing without saving within a macro
Or
ActiveWorkbook.Close False -- Regards Ron de Bruin http://www.rondebruin.nl "Frank Kabel" wrote in message ... Hi use application.displayalerts=false ActiveWorkbook.Close -- Regards Frank Kabel Frankfurt, Germany "okanem" schrieb im Newsbeitrag ... I am trying to close a spreadsheet without saving any changes to it from within a macro, but at the moment it keeps asking me do I want to save changes. The code so far is Windows("control of contract - item 1.xls").Activate ActiveWorkbook.Close Can someone help. I don't want to save before closing which would get rid of the message because it takes about 10 seconds to close. Thanks for any replies Okanem -- okanem --------------------------------------------------------------------- --- okanem's Profile: http://www.excelforum.com/member.php...fo&userid=9301 View this thread: http://www.excelforum.com/showthread...hreadid=320054 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving and Closing | Excel Discussion (Misc queries) | |||
| How to code on Macro on saving and closing a file? | Excel Worksheet Functions | |||
| macro help - closing without saving & empty clipboard | Excel Discussion (Misc queries) | |||
| closing & saving | Excel Worksheet Functions | |||
| VBA - closing without saving changes | Excel Programming | |||
![okanem[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
