PDF print driver is creating multiple PDF files from Excel

[joken99]

I have an Excel 2010 workbook that contains 7 separate sheets.  I have set up a visual basic macro to print all of the sheets in group mode and restart the page numbering for each tab. It works great when I print the hard copy, but when I print it to our CutePDF to create the pdf file, I am getting prompted to save each sheet as a separate file. Is there any way to make the Acrobat print driver create just one file instead of seven separate ones?  Thanks for the help!!!

[Bernd Alheit]

CutePDF is not a Adobe product.

[joken99]

Hi Bernd,  Long time no talk to!!  What about the print driver that came with Adobe Acrobat 11?  If you have any suggestions, I'd love to give them a try.  Have a great day!!!!!

[Dov Isaacs · Accepted solution]

Use the Acrobat PDFMaker that is installed with Adobe Acrobat instead of printing to PDF, either with the Adobe PDF PostScript printer driver instance or some other third party product. PDFMaker supports a single PDF from multiple sheets of a single spreadsheet.

          - Dov

[joken99]

Hi again Dov,

Since you were so helpful with my earlier question, Please take a look at an old case that is still open  since August 21017. The text of the case is as follows: Any help you could give us would be greatly appreciated!!!!!

Side by Side Comparisons without callouts

Some of our users used to get side by side comparisons that they
didn't have to "mouse over" .to view.  They would prefer it if
they could just have 2 pdf files displayed side by side showing deleted text
struck through and other changes indicated in a side by side comparison without
callouts.  It sounds like the change occurred when they went to Acrobat
Pro 11.  Thanks for the help!

Have a great afternoon!!!

Ken K. – 2191

[joken99]

I do have Acrobat 11 Pro on my PC. Please let me know if I have to have someone from IT install or set up something so I can use Pagemaker.  Thanks for your assistance and patience!!!

Have a great night!!!!

Ken K. - 2191 

[joken99]

Thanks for the help Dov!!  I'll have our IT folks install the Acrobat PDF Maker on my pc and I should be good to go!!!  Have a great afternoon!!!!!

Ken K. - 2191

[Dov Isaacs]

Note that PDFMaker for Microsoft Office applications is part of Acrobat Standard and Acrobat Pro. If you already either Acrobat Standard or Acrobat Pro installed on your system, PDFMaker should already be available in your Office applications.

          - Dov

[joken99]

I'm not sure what I have to ask IT to do so I can see if I can run PDF Maker to see if I can get it to print just one PDF file instead of prompting me to save each Tab of the Excel file as a separate PDF  Sorry to take so much of your time with this question,  but I'll get there eventually!

Thanks again for your help!!!

Ken K. - 2191