| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I bypass the message to save when closing a file by macro?
When closing a file via macro, I continue to get the message do I want to
save this file. Can someone help me bypass that message. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I bypass the message to save when closing a file by macro?
Try...Application.DisplayAlerts=False |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I bypass the message to save when closing a file by macro?
The best approach would be this:
Dim File1 as Workbook Set File1 = Workbooks("YourWorkbook.xls") File1.Close False Charles sjmpcec @ anon. com wrote: When closing a file via macro, I continue to get the message do I want to save this file. Can someone help me bypass that message. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I bypass the message to save when closing a file by macro?
activeworkbook.Close SaveChanges:=False
-- Regards, Tom Ogilvy " wrote: When closing a file via macro, I continue to get the message do I want to save this file. Can someone help me bypass that message. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to Save File to specific location when closing | Excel Discussion (Misc queries) | |||
| Custom message at opening or closing of file | Excel Discussion (Misc queries) | |||
| How to skip the save file notoification on file closing? | Excel Worksheet Functions | |||
| Save on closing file | Excel Programming | |||
| Unexpected error message on closing an Excel file | Excel Discussion (Misc queries) | |||
Linear Mode
