Print Multiple Workbooks from a Directory in Excel 2007/2010

Normally, if you need to print multiple workbooks, you may need to separately open, print and close all workbooks. But with Kutools for Excel’s Print Multiple Workbooks Wizard, you can quickly:

Print multiple workbooks or text files in the same directory;
Print multiple workbooks or text files in multiple directories.

Click "Kutools">>"Printing">>"Print Multiple Workbooks Wizard". See screenshots (Fig. 1)

Fig. 1: Print Multiple Workbooks Wizard

Note: Print Multiple Workbooks Wizard is easy to use, it will guide you through to specify the whole print operation easily.

Usage:

Step 1：Choose the file directory and click Next. See screenshot (Fig.2):

Fig. 2: Print Multiple Workbooks Wizard - Step 1

Step 2：Choose the files to be printed and click Next. See screenshot (Fig.3):

(1) If you choose “All of the files to be printed are in the same directory” option, and click “Next” go to next step. See screenshot (Fig. 3).

Click Browse to specify the directory;
Specify the type of files to be printed, or enter a File specification;
Click Next;

Note: The Match files will indicate the number of files available to be printed.

Fig. 3: Print Multiple Workbooks Wizard - Step 2 (in the same directory)

(2) If you choose “The files to be printed are in multiple directories” option, and click "Next" to go to next step. See Screenshot (Fig. 4).

Click Add Files to select all files you want to print;
Click Next;

Fig. 3: Print Multiple Workbooks Wizard - Step 2 (in multiple directories)

Step 3：Specify the type of sheets to be printed in the workbooks, and click "Next";

Fig. 5: Print Multiple Workbooks Wizard - Step 3

Step 4：Specify the printing settings, click Finish to start printing.

The following options are available for the printing settings:

Quiet Mode: if selected, it will turn off the screen updating. All opened and printed files will be invisible.

Generate a summary report: If selected, it will generate a report, which describes the info of the files to be printed and also lists the errors that occurred.

Disable Auto macros: If selected, the auto macros will not be executed in the opened workbooks.

Password:
For Prompt for passwords option, it will prompt a dialogue asking for password when it opens the file that needs a password.
For Use this password option, if you specify a password, it must be the same password for each file in the file list.

Links & remote references: If selected, it will update the links and remote references when each file is opened.

Note: It is better to check “Generate a summary report” option, for it let you know the details and the errors that occurred in the printing.

Fig. 6: Print Multiple Workbooks Wizard - Step 4