+ Reply to Thread
Results 1 to 6 of 6

exporting selected parts in pdf?

  1. #1
    Registered User
    Join Date
    10-19-2014
    Location
    zagreb
    MS-Off Ver
    2013
    Posts
    2

    exporting selected parts in pdf?

    Is it possible to export selected part of workbook in pdf format?
    thx

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: exporting selected parts in pdf?

    set your print area to things you want to exported then set printer to pdf (not sure which one you would have) and print
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: exporting selected parts in pdf?

    Try this simple Macro.. for all you want...
    It will save all pages with printable areas in the workbook to the path where original workbook resides..
    Please Login or Register  to view this content.
    Regards,
    Vikas Gautam
    Excel-buzz.blogspot.com

    Excel is not a matter of Experience, its a matter of Application.

    Say Thanks, Click * Add Reputation

  4. #4
    Registered User
    Join Date
    10-19-2014
    Location
    zagreb
    MS-Off Ver
    2013
    Posts
    2

    Re: exporting selected parts in pdf?

    Thank you
    but this havent resolve my problem because it exports whole active workbook an I need only a selected part....
    thank you anyway

  5. #5
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: exporting selected parts in pdf?

    If you have Acrobat that creates PDFs, it installs a "printer" when installed. Other programs may do the same. If that is the case, you can set the print area and print that to a PDF.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  6. #6
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: exporting selected parts in pdf?

    Okay then try this..
    Select the sheets you wanna print using CTRL + Click and
    Run the following macro..

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Exporting selected worksheets
    By emir0514 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-12-2014, 06:01 PM
  2. Exporting selected data from Excel to Word
    By xxgirlinbluexx in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-08-2013, 12:22 PM
  3. Exporting selected values into a new CSV file
    By excelbegi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-14-2012, 10:55 PM
  4. Selected parts of worksheet needed in word document
    By Andreass in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-03-2007, 02:01 AM
  5. Exporting selected data / automation
    By dougb415 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 09-21-2005, 04:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1