batch convert

[patrickv]

ok so i have an excel file with like 116 sheets + charts. now i want to convert to pdf.
Acrobat 7 does that from excel but it does it one sheet at a time.
is there a way to convert all sheet in this file to pdf ?

right now am gonna install the free pdfcreator, if that is of any use

 

[munkyeetr]

I found this freeware app: http://www.freedownloadscenter.com/Utilities/Misc__Utilities/Free_PDF_Converter.html

I haven't tried it myself, but maybe it will do what you need.

 

[Runn3r.cze]

openOffice.org can also save documents in pdf. and it supports .xls files from mcrosoft excel. so you can install oo.o open your document in it and save as pdf, but i'm not sure how does it works with the sheets

 

[patrickv]

openOffice.org can also save documents in pdf. and it supports .xls files from mcrosoft excel. so you can install oo.o open your document in it and save as pdf, but i'm not sure how does it works with the sheets

yeah i know but dude you're way off course and i dont have time to install Oo, anyhows , thanks for the link munkyeetr i will check it. i did a test with a 10 sheet excel doc i made and use that pdf creator to convert it works good but one problem with it is that it saves sheet 1 alone, while sheet 2 to 10 saves together.

thanks again cheers

 

[patrickv]

I found this freeware app: http://www.freedownloadscenter.com/Utilities/Misc__Utilities/Free_PDF_Converter.html

I haven't tried it myself, but maybe it will do what you need.

hehe, no way i won't do it that way, not ever, thats web based then they'l email me back ?..i don't want them to see my file its confidential.
but thanks anyway

 

[munkyeetr]

i did a test with a 10 sheet excel doc i made and use that pdf creator to convert it works good but one problem with it is that it saves sheet 1 alone, while sheet 2 to 10 saves together.

Try adding an new sheet and putting in the place of "sheet1", add some type in a few cells so it has content and try again...maybe it will export the new sheet as the single .pdf, and keep the rest together.

worth a shot.

 

[PC Hobbyist]

You should be able to just open your Excel file (i.e. workbook) and click on Print - then choose the adobe PDF writer as the printer - and also select the option to print "entire workbook".

 

[patrickv]

You should be able to just open your Excel file (i.e. workbook) and click on Print - then choose the adobe PDF writer as the printer - and also select the option to print "entire workbook".

I allready completed the conversion dude, but thanks anyways