Converting Excel to PDF?

[Sigi Rindler]

I have a huge text (several hundred pages) of Turkish in Excel format.
Since some special characters are being dropped or altered when printing the
Excel file, I need to convert the file into PDF to get a proper printout.
Unfortunately, I am only able to convert on a page per page basis. Is there
any "trick" to get the entire Excel file converted in one go? There must be
something in the setrtings...

 

[Sigi Rindler]

Ahem... I have to revise my previous post! These are not "pages" but sheets.
I could almost figure that one needs to handle them one by one and not in
one go. However, if there is a chance to do the conversion in one go, I'd
appreciate to know.

 

[Ken Puls]

I use a program called PDFCreator to make my PDF's. I have a VBA
routine at my site that will do this:
http://www.excelguru.ca/node/21#MultiSingle

HTH,

Ken Puls, CMA - Microsoft MVP (Excel)
www.excelguru.ca

 

[Guest]

Please explain briefly how to use your VBA routine. I've gone to your website
and downloaded PDFCreator and it works fine, but I can't figure out how to
make your routine work with it. I'm kind of VBA semi-illiterate!

Thanks.

 

[Ken Puls]

Okay, I'll walk you through as if you're totally VBA illiterate, just in
case.

-Copy the code for the "Print Multiple Worksheets to a Single PDF File"
routine
-Go into Excel and Press Alt+F11 to enter the visual basic editor (VBE)
-If you don't see a windows explorer tree at left, press Ctrl+R to expose it
-Navigate until you find your project
-Right click your VBA Project and choose Insert|Module
-Paste the code in the screen that shows up
-Go to the Tools menu and choose References
-Scroll down the long list until you find PDF Creator. Check that box
-Close the VBE and save your workbook

Just for reference, you will now get a macro warning every time you open
this workbook.

Now, to run it, press Alt+F8 and a list of macros will pop up. Choose
"PrintToPDF_MultiSheetToOne_Early", sit back and wait.

Your completed document will end up in the same file as your workbook,
and will be called Consolidated.pdf

HTH,

Ken Puls, CMA - Microsoft MVP (Excel)
www.excelguru.ca

 

[Guest]

THANK YOU, THANK YOU, THANK YOU FOR THE CRYSTAL CLEAR DIRECTIONS.

Much appreciated!!

 

[gumyrbek]

Why not make it simpler?

Just select all sheets by right-click on any of the sheet tab. Once
selected - convert to pdf.
No need for these fancy VBA stuff ) I converted 34 sheets into one file in
2 minutes.

Vous a la. Good luck!

Cheers.

 

[Ken Puls]

Hi gumyrbek,

What program do you use for PDF creation? With PDF Creator, nothing
comes up on the right click for the sheets that will let you convert to
PDF. In addition, when you select "Entire Workbook" in the print
dialog, it still prints to multiple files.

With PDF Creator, the only way I have found to do this is via VBA.

Ken Puls, CMA - Microsoft MVP (Excel)
www.excelguru.ca

 

[Gord Dibben]

Ken

I use the method by Dale Nurden that I posted to this thread.

Here it is again..........

http://www.rcis.co.za/dale/info/pdfguide.htm

Just group the sheets and print to file with the PS printer you have installed
per Dale's instructions.

Convert the *.ps file to *.pdf

Longer way around but successful.


Gord

Hi gumyrbek,

What program do you use for PDF creation? With PDF Creator, nothing
comes up on the right click for the sheets that will let you convert to
PDF. In addition, when you select "Entire Workbook" in the print
dialog, it still prints to multiple files.

With PDF Creator, the only way I have found to do this is via VBA.

Ken Puls, CMA - Microsoft MVP (Excel)
www.excelguru.ca

Gord Dibben MS Excel MVP