A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"Save file before closing"



 
 
Thread Tools Display Modes
  #1  
Old June 1st, 2010, 05:11 PM posted to microsoft.public.excel.misc
mkilbour
external usenet poster
 
Posts: 1
Default "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?
Ads
  #2  
Old June 1st, 2010, 06:54 PM posted to microsoft.public.excel.misc
Luke M[_4_]
external usenet poster
 
Posts: 451
Default "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  
Old June 1st, 2010, 08:05 PM posted to microsoft.public.excel.misc
Gary Brown[_6_]
external usenet poster
 
Posts: 61
Default "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?

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:13 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.