Print 2 Excel sheets to same PDF File

Hi,
I need to print 2 excel sheets into the same PDF File (I use Primo PDF if that matters).
Currently the way it works is that it selects sheet then prints it, then call another macro and then selects that sheet and prints it.
But when it does that it is basically creating 2 separate PDF Files which I don't want.
Also I don't need to have the print dialog box come up twice.
Any Ideas?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hi 6StringJazzer,
Thanks! I seem to be getting an error in

Please Login or Register  to view this content.

line when I try it.
My file is to large to upload

OK, this one was tested in a mock-up.

Please Login or Register  to view this content.

Thanks, Sorry about late reply, but works good!

This could also be exported directly to PDF natively in 2007+ without having to bring up the print dialog for the user and going through a third-party PDF writer. Do you need to go through the print dialog, or would you prefer to go direct to PDF?

Sure, what would that look like, may be easier...