Printing Only Selected Sheets from Multiple Workbooks to A Single PDF File

[westwojr]

So what I have collection of workbooks that are generally of the same layout but not exactly. I only wish to print the worksheets from each workbook whose names are included in an array, say segment(a:f), in the order of the array.

I also wish to print all of these worksheets to a single pdf. I have managed to write a macro to print only the desired worksheets. However, I still am unsure how to handle the following problems.

1: Occasionally the tabs are not ordered in the array order. As such, while they will all print, they remain in the order as found in the workbook instead of as desired
2: Am really at quite a loss to how to get all of the workbooks into one PDF. My inclination is to somehow select all of the desired sheets from all of the workbooks at once prior to printing, or somehow append subsequent printings onto an already created PDF. Unfortunately I am unsure how to do either of those options.

See below for the code I am using to print from one workbook.

Please Login or Register  to view this content.

[AlphaFrog]

Try something like this...

Please Login or Register  to view this content.

[westwojr]

The reordering procedure was working, though I am I'm still unsure how to address the multiple workbook piece?

Also, when I come across the export to PDF code, I receive an invalid procedure call or argument error. In my limited past, I had always just printed with the Adobe PDF printer, so I am unfamiliar with what may be causing the error in the export statement...