Hi Guys,
I'm using the following macro to save worksheets as pdf file. This macro successfully saves all sheets in a given workbook as individual pdfs.
But my requirement is to export only active worksheets as individual pdf & none of the file should exceed 150kb size.
Any help will be appreciated. Thanks Andy
Please Login or Register to view this content.
1) Can you explain what you mean by "active sheets", exactly?
2) The ExportToPDF feature doesn't have any tools to controls filesize. Some people have reported this feature sometimes saves PDFs in sized larger than normal. Suggestions I've seen to resolve it include:
- confirming the printarea is set as small as possible
- using xlsm files instead of .xls files
- create and set a non-existent printer as the default before using the ExportToPDF function.
Last edited by JBeaucaire; 09-05-2014 at 04:25 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks