I am using excel 2007. I want to convert each sheet into a separate pdf file. If i select multiple sheets and convert, it converts all of them into one file. I have 20 sheets in a file. Right now I am converiting them manually one at a time. I dont have adobe and am a VBA novice. Any suggestions? Appreciate your help.
I don't have XL'07, You can use the Macro recorder to Get the code to PDF in XL'07, then use a Worksheet Loop to PDF each Sheet.
For me it would look something like this.
Then I would have to Save Each PDF File
Please Login or Register to view this content.
Last edited by davesexcel; 09-03-2010 at 07:57 PM.
hey thanks a lot this code helped me a lot
now i can convert them smoothly... ive been using http://exceltopdf.org/ but the pdfs would never open :/
now i can do it super fast :D
thank you
@TheHulk I tried your advice but it don't allow multiple uploads?
Found online-pdf.org but how to know if it's safe? tnx ^^
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks