Results 1 to 4 of 4

Thread: Article: Print To PDF Using Microsoft's PDF/XPS Add-in

  1. #1
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,251
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider

    Article: Print To PDF Using Microsoft's PDF/XPS Add-in



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training) or with my book M is for Data Monkey!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  2. #2
    Is is possible to specify "2 pages per sheet" as you can with a physical printer? The end result would be two (or more) worksheet charts on one PDF page.

  3. #3
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,251
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Hi Garry,

    I believe that the code will inherit the default page setup. So if you have your normal print jobs coming out that way, it should replicate it.

  4. #4
    Hello Ken; I've been searching for a methodology to program a report output from excel into a PDF document and your code above works great. However, I have noticed 1 thing and then have a question on another as I'm stumped as to what to do for fixing one issue and figuring out how to print only the specific "pages" on a worksheet vs all the "pages" on a worksheet. Problem #1. After I ran you code and fixed the errors, my worksheet that I collect my data on is now locked and it seems I can't unlock it, yet there is no password protection on the worksheet, though it was protected. I go to design mode and my active x controls are not accessible, they've shrunk in size and moved to a location I would prefer they not be. I've not searched for a solution on that yet, but I thought I'd comment as perhaps you have seen this action before? The other part of my question is, in the PDF print/save process you provided, is there a way to only print the specific pages on a worksheet? I have an audit form that if I print the worksheet out to provide as report, I only want pages 1 thru 6 to print out. The other "6" pages are nothing but error checks to warn the user they've selected too many check boxes in a row or to allow the end user to know how many questions remain on their audit they are performing. I am trying to print just those 6 pages on the audit form and then a separate sheet that has a summary report. I've got the summary report to print along with the 12 Total pages on the audit worksheet. I'm struggling trying to figure out if I can reduce that to only the 7 pages I actually need. Hopefully you can point me in a direction I can go to get this resolved. Thanks in advance if you've got any suggestions. Best regards, Ted Herrmann

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •