Printing from Excel to PDF

[danielabbott2000]

I have 3 different workbooks with multiple tabs and some of the tabs have multiple pages. I have a macro setup to print certain pages from each workbook in a cetrain order( like i have one tab that has 30 pages one for each employees total sales, on another tab i have commission figures for each employee, and another workbook has previous years information.) Is there a way i can get to print to one PDF file like where Employee A's sheets print together then it goes to Employee Bs? Right now I can set the default printer to my PDF printer but every time it changes from workbook to workbook or tab to tab to print the give pages i need it makes me save a new file for each page.

 

[kpark91]

Instead of creating a macro for every problem. (it takes time)
It'd be better if you can install a PDF printer which you can append unless you will be doing this task everyday.

 

[danielabbott2000]

I have Adobe Acrobat Standard 9 that shows up as a printer option for me from excel but i dont know how to append. I only run this process once a month and currently i have the macro print in the order for me and then i go scan it on scanner but it isnt as readable. My process prints a total of about 80 pages in a certain order.

 

[kpark91]

I'm not too sure Adobe Acrobat Standard 9 comes with an PDF appender.
I know my colleagues have downloaded PDF appending freewares from Google but I'm not sure of the name of it. I'm sure you can search it up on the internet and find one that's suitable or somebody else could answer to this thread :P
Best of luck!

 

[danielabbott2000]

Thanks i will try that and see if it works or if anyone else has any ideas thanks again.