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

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,642
Messages
5,832,836
Members
430,171
Latest member
Ashish7860

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