+ Reply to Thread
Results 1 to 11 of 11

Exporting each sheets to PDF's as a separate file

  1. 07-12-2018, 04:17 PM #1
    T.I.
    T.I. is offline
    Forum Contributor
    Join Date
    03-05-2018
    Location
    Tbilisi, Georgia
    MS-Off Ver
    2013, 2016
    Posts
    273

    Exporting each sheets to PDF's as a separate file

    Hi, experts!

    Is it possible to export each sheet of workbook to PDF using names from cells of particular sheet?
    For ex:
    Sheet1: A1=Name1
    Sheet1: A2=Name2
    Sheet1: A3=Name3

    I found this kind of code in internet, but for exported PDF's it uses names of sheets...

    Please Login or Register  to view this content.
    Thanks in advance.
    Reply With QuoteRegister To Reply
  2. 07-12-2018, 04:30 PM #2
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Exporting each sheets to PDF's as a separate file

    Try this
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here
    Reply With QuoteRegister To Reply
  3. 07-12-2018, 04:49 PM #3
    T.I.
    T.I. is offline
    Forum Contributor
    Join Date
    03-05-2018
    Location
    Tbilisi, Georgia
    MS-Off Ver
    2013, 2016
    Posts
    273

    Re: Exporting each sheets to PDF's as a separate file

    Thank you it worked.
    But at the end it shows an error.
    error.png
    However all sheets were successfully converted and Sheet1 itself omitted.
    Reply With QuoteRegister To Reply
  4. 07-12-2018, 05:33 PM #4
    jolivanes
    jolivanes is offline
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,692

    Re: Exporting each sheets to PDF's as a separate file

    Do you have hidden sheets?
    Reply With QuoteRegister To Reply
  5. 07-13-2018, 12:26 AM #5
    T.I.
    T.I. is offline
    Forum Contributor
    Join Date
    03-05-2018
    Location
    Tbilisi, Georgia
    MS-Off Ver
    2013, 2016
    Posts
    273

    Re: Exporting each sheets to PDF's as a separate file

    Quote Originally Posted by jolivanes View Post
    Do you have hidden sheets?
    No, all sheets are visible.
    Reply With QuoteRegister To Reply
  6. 07-13-2018, 04:34 AM #6
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Exporting each sheets to PDF's as a separate file

    Can you post sample of your workbook?
    Reply With QuoteRegister To Reply
  7. 07-13-2018, 04:58 AM #7
    T.I.
    T.I. is offline
    Forum Contributor
    Join Date
    03-05-2018
    Location
    Tbilisi, Georgia
    MS-Off Ver
    2013, 2016
    Posts
    273

    Re: Exporting each sheets to PDF's as a separate file

    Sure. Attached.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 07-13-2018, 12:30 PM #8
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Exporting each sheets to PDF's as a separate file

    Try this
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  9. 07-13-2018, 12:44 PM #9
    jolivanes
    jolivanes is offline
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,692

    Re: Exporting each sheets to PDF's as a separate file

    Your Sheet Names are different from the Names in Sheet PDF
    Reply With QuoteRegister To Reply
  10. 07-13-2018, 12:44 PM #10
    T.I.
    T.I. is offline
    Forum Contributor
    Join Date
    03-05-2018
    Location
    Tbilisi, Georgia
    MS-Off Ver
    2013, 2016
    Posts
    273

    Re: Exporting each sheets to PDF's as a separate file

    Now works like a charm! Thank you so much.
    Reply With QuoteRegister To Reply
  11. 07-13-2018, 12:45 PM #11
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Exporting each sheets to PDF's as a separate file

    You're welcome. Glad I can offer some help
    Please mark the thread as solved
    Regards
    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. Excel file into separate sheets based on states
    By needtodownload in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-18-2017, 04:05 PM
  2. import txt file into separate excel sheets and look for a specific row to add
    By tuspilica in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-14-2017, 02:58 PM
  3. Question Specifically about Google Sheets. Exporting as stand-alone file?
    By leerosario in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-24-2016, 11:03 PM
  4. VBA help needed exporting data from several separate sheets into multiple invoices
    By dellicio in forum Office 365
    Replies: 0
    Last Post: 10-03-2014, 07:23 AM
  5. Can you e-mail separate sheets in an Excel Workbook file?
    By FruityPebbles in forum Excel General
    Replies: 5
    Last Post: 04-01-2012, 03:05 AM
  6. Generating muiltple sheets from cell data and exporting as a text file
    By troth in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-24-2011, 01:25 PM

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