Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
closing a spreadsheet
Is there a way to close a spreadsheet via a macro without it prompting to be
saved? I have a macro that pulls in a text file, formats it and then saves the file as a delimited text file. When I go to close the file it asks if I want to save the changes, even though I have not made any since the macro ran and saved it. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
closing a spreadsheet
ActiveWorkbook.Close SaveChanges:=False
will do that. -- Regards, Tom Ogilvy "Cyberwolf" wrote in message ... Is there a way to close a spreadsheet via a macro without it prompting to be saved? I have a macro that pulls in a text file, formats it and then saves the file as a delimited text file. When I go to close the file it asks if I want to save the changes, even though I have not made any since the macro ran and saved it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Faster closing of large spreadsheet | Excel Discussion (Misc queries) | |||
VB to clear any filters when closing a spreadsheet | Excel Discussion (Misc queries) | |||
Closing Excel spreadsheet | Excel Discussion (Misc queries) | |||
Dialog box when closing an unsaved spreadsheet | Excel Discussion (Misc queries) | |||
Question on Removal of Column Filtering Upon Closing of Spreadsheet | Excel Programming |