+ Reply to Thread
Results 1 to 4 of 4

Save Multiple Worksheets as Individual PDFs

  1. 02-25-2014, 01:41 PM #1
    jmk8602
    jmk8602 is offline
    Registered User
    Join Date
    11-12-2011
    Location
    america
    MS-Off Ver
    Excel 2003
    Posts
    19

    Save Multiple Worksheets as Individual PDFs

    I have a workbook with 100 sheets and I want to quickly save each sheet as its own PDF file. I was able to find some instructions, but the code keeps giving me an error at the highlighted spot. Any insight would be appreciated.


    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 02-25-2014, 09:46 PM #2
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Save Multiple Worksheets as Individual PDFs

    What is the error message?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]
    Reply With QuoteRegister To Reply
  3. 02-26-2014, 12:49 AM #3
    Xx7
    Xx7 is offline
    Forum Contributor
    Join Date
    01-30-2011
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2010
    Posts
    604

    Re: Save Multiple Worksheets as Individual PDFs

    Try this...


    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 02-26-2014, 01:26 PM #4
    jmk8602
    jmk8602 is offline
    Registered User
    Join Date
    11-12-2011
    Location
    america
    MS-Off Ver
    Excel 2003
    Posts
    19

    Re: Save Multiple Worksheets as Individual PDFs

    Quote Originally Posted by Xx7 View Post
    Try this...


    Please Login or Register  to view this content.
    This worked absolutely perfectly. You are the best ever.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA One Sheet Save As Multiple PDFs from Cells
    By ucirsharma in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-04-2013, 05:02 PM
  2. Macro to save excel worksheets as pdfs and change hyperlinks to work in pdf format
    By crnadeau4 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-06-2013, 12:18 PM
  3. Help Creating Individual PDFs for several tabs on a work sheet
    By Cperez0831 in forum Excel General
    Replies: 2
    Last Post: 02-03-2013, 04:28 PM
  4. [SOLVED] marco to save all worksheets as PDFs, based on cell info in sheet.
    By abagnall in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-16-2013, 09:31 AM
  5. Macro to print multiple worksheets to multiple PDFs.
    By ryanwood17 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-14-2010, 02:07 AM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1