Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Save file before closing"
Using Excel 2007 on Windows XP: Monthly I select hundreds of Excel files from
Windows Explorer, right click and select Print. It would open an Excel file, print it, close it and repeat for the next file. I could go home for the evening, and the hard copies would be on my printer when I came in the next morning. I am now getting a prompt asking if I want to save the file before closing it. This means I have to be present and respond for every file it opens. How can I disable this prompt? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Save file before closing"
Sounds like at least one of the files has a volatile function such as:
=NOW() Possible workaround: Open XL, change calculation mode to manual (Tools-Options-Calculation), then open all the files and print. This would prevent Volatlite functions from recalculating. On the other hand, if you wrote a macro to open & print all your files, the command code needed at the beginning would be: Application.DisplayAlerts = False -- Best Regards, Luke M "mkilbour" wrote in message ... Using Excel 2007 on Windows XP: Monthly I select hundreds of Excel files from Windows Explorer, right click and select Print. It would open an Excel file, print it, close it and repeat for the next file. I could go home for the evening, and the hard copies would be on my printer when I came in the next morning. I am now getting a prompt asking if I want to save the file before closing it. This means I have to be present and respond for every file it opens. How can I disable this prompt? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Save file before closing"
When you close each workbook, use something like...
application.ActiveWorkbook.Close savechanges:=False -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "mkilbour" wrote: Using Excel 2007 on Windows XP: Monthly I select hundreds of Excel files from Windows Explorer, right click and select Print. It would open an Excel file, print it, close it and repeat for the next file. I could go home for the evening, and the hard copies would be on my printer when I came in the next morning. I am now getting a prompt asking if I want to save the file before closing it. This means I have to be present and respond for every file it opens. How can I disable this prompt? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 | Excel Discussion (Misc queries) | |||
Opening and Closing a "EXE" file within Excel | Excel Discussion (Misc queries) | |||
"Save" and "Save As" options greyed out - "Save as Webpage" option | Excel Discussion (Misc queries) | |||
Disabling "SAVE AS" option under "File" | Excel Discussion (Misc queries) | |||
excel 02 always asks "save changes?" when closing unaltered file | Excel Discussion (Misc queries) |