For my job I have to print multiple excel files. When I want to print them out I select all the files in windows explore and select print. When I did it this way the computer would go through and open a file, print it, then close it and go on to the next one. I recently had the power supply and mother board changed in my computer and now when ever I go to print the files I am prompted to save the file before each one closes. It still prints them but it is non productive if I have to sit there and click yes or no for every file that I want to print. Is there a way that I can make it just print and close the way it used to without having to save? Thank You
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Printing Multiple Excel Files
- Thread starter Moon Boi
- Start date
Smitty
Legend
- Joined
- May 15, 2003
- Messages
- 29,536
Welcome to the Board!
If you have volatile formulas (TODAY(), NOW(), etc.) they recalculate when the wb is opened, which will prompt you to save. Prior to printing you should be able to go to Tools-->Calculation-->Set it to Manual to prevent it. Just remember to set it back to Automatic when you're done.
Otherwise you can use some VBA code to loop through all the files in a folder, print & close. In VBA you can easily suppress messages with Application.DisplayAlerts = False.
Hope that helps,
Smitty
If you have volatile formulas (TODAY(), NOW(), etc.) they recalculate when the wb is opened, which will prompt you to save. Prior to printing you should be able to go to Tools-->Calculation-->Set it to Manual to prevent it. Just remember to set it back to Automatic when you're done.
Otherwise you can use some VBA code to loop through all the files in a folder, print & close. In VBA you can easily suppress messages with Application.DisplayAlerts = False.
Hope that helps,
Smitty
Upvote
0
Similar threads
- Question
- Question
