Thank you for patiently waiting. There is a way to print the whole workbook automatically using a Macro. However, this approach needs to actually open each file and then run the macro to print the workbook completely.
Since you don't want to open individual Excel files in order to print them, it requires to be a tool to be able to do that. By tool, I am referring to an Excel plugin.
After few hours of checking and testing, I found this tool to actually do what you want. Please click on this link:http://www.extendoffice.com/product/kutools-for-excel.html
This is what I recommend because I tested it myself. I downloaded a tree trial and it just worked.
You can download a free trial and then install the software.
Then open MS Excel and then the tool is enabled as a plugin.
When you open Excel, click on Enterprise tab. This tab is added to your Excel when you installed the tool.
Then click on Printing Tools then click on Print Multiple Workbook Wizard.
Then in the first wizard box, select "All the files to be printed is in the same directory" then click Next.
Then click Browse button to select the directory where the Excel files that you want to print resides.
Then click the check box "Excel workbooks" then click Next.
The files inside the folder will be shown and checked by default.
For the printing sheet type, select "Entire workbook".
Just accept default settings on the last screen then click on Finish.
Then the workbooks will be printed to your default printer.
I suggest that you try the tool and try to add few excel files only in the folder that you want to print then test if printing is fine.
Please remember to rate my service positively (3-5 stars/faces)
once you have all the information you need. Tips
are always highly appreciated!
If you have any other questions, please do not rate me negatively
. Instead, please ask me or reply to me
– I’ll be happy to respond.