Print multiple excel tables to a single pdf document?
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
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?
Last edited by shg; 04-09-2010 at 05:35 PM.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks