Print multiple excel tables to a single pdf document?

[Jamesulan]

Hello,

I am trying to print multiple excel tables, which are the same size (15 cells wide and 28 cells tall) and in the same worksheet, to a single pdf document, so that each table has its own landscape page in the pdf document. I have attached an excel file to illustrate the source data with which I'm working. If you share a solution you will literally save me over 10 hours of pdf'ing. Any help you can offer will be greatly appreciated.

Also, I have Microsoft Excel 2003 and Adobe Acrobat 6.0 Standard!

Thanks and I hope to hear from you.

Sincerely,
James Ulan

[shg]

When I need to do this, I use code to print the individual PDFs to a separate directory, and then use Acrobat to combine them to a single PDF. The second step takes about five seconds (File > Create PDF > Merge files into a single PDF). I'm sure it could be automated as well, but it's such a minor itch I've never scratched it.

Is what you're doing more complicated?