Print Worksheet to PDF Files

[Guest]

Please provide vba code to create PDF files for each worksheet in a workbook.

Each PDF file (using CutePDF) will be titled according to the contents of a
cell

This sounds very easy, but I've had much trouble in executing.

 

[Guest]

I have been able to get this to work. Still working on the PDF. I know it
can be done.

ActiveSheet.PrintOut , prtofilename:="Microsoft Office Document Image Writer"

 

[Guest]

Jim...

Thanks for the reply, but ive tried something similar. Excel only produces a
file titled "Microsoft Office Document Image Writer" (or is set as the file
name). It does not produce a PDF file.

Sean

 

[Guest]

http://www.rondebruin.nl/tips.htm has tips for doing this in Excel 2007 but
no mention of earlier versions. I may have been thinking of 2007 when saying
there had to be a way.

If you have Office 2007 you are in luck.

 

[Jon Peltier]

Ken Puls shows how to do it with PDFCreator, another free PDF printer
driver. Unlike most of them, PDFCreator can be manipulated by VBA.

http://excelguru.ca/taxonomy/term/21

- Jon

 

[Ron de Bruin]

Hi Jon

I add a link to Ken's site on my 2007 PDF page.
http://www.rondebruin.nl/pdf.htm