Is it possible to export selected part of workbook in pdf format?
thx
Is it possible to export selected part of workbook in pdf format?
thx
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.
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
Thank you
but this havent resolve my problem because it exports whole active workbook an I need only a selected part....
thank you anyway
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
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks