Printing Multiple Excel Files

Moon Boi

New Member
Joined
Jul 26, 2007
Messages
1
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
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

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
 

Watch MrExcel Video

Forum statistics

Threads
1,130,167
Messages
5,640,539
Members
417,151
Latest member
ChickenTenderer

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top