I need a macro that will print specific sheets from several workbooks as ONE print job. It would be relatively easy (I imagine) to get excel to print each sheet separately one by one, but I need it to be combined in one print job as the printer is going to combine it into a booklet for me. Example: Workbook 1 Need to print: Sheet2 Sheet10 Sheet11 Sheet12 Sheet13 Sheet14 Workbook 2 Need to print Sheet3 Sheet4 Sheet5 So, can anyone tell me how to select multiple sheets from multiple workbooks and then print (using VBA)? Thanks in advance for any assistance IF it makes it any easier, I can hide all the unwanted sheets from both workbooks so that the only visible sheets are those I want to print. Not sure if that helps.

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.

Create one print job from multiple workbooks

Thread starter Zakkaroo
Start date Sep 27, 2011

Zakkaroo

Active Member

Sep 27, 2011

I need a macro that will print specific sheets from several workbooks as ONE print job. It would be relatively easy (I imagine) to get excel to print each sheet separately one by one, but I need it to be combined in one print job as the printer is going to combine it into a booklet for me.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com

ffice

ffice" /><o

></o

>
Example:
Workbook 1
Need to print:
Sheet2
Sheet10
Sheet11
Sheet12
Sheet13
Sheet14
<o

></o

>
Workbook 2
Need to print
Sheet3
Sheet4
Sheet5
<o

></o

>
So, can anyone tell me how to select multiple sheets from multiple workbooks and then print (using VBA)?
<o

></o

>
Thanks in advance for any assistance

IF it makes it any easier, I can hide all the unwanted sheets from both workbooks so that the only visible sheets are those I want to print. Not sure if that helps.