Macro to save the excel sheet to PDF

[Neil Holden]

Hi, can someone help me, I am trying to create a macro for when pressed save
the entire workbook to PDF.

Is this possible? Please Help.

Neil.

 

[Mike H]

Neil,

I have 'heard' it's supported in E2007 but not in earlier versions. I've
used the free utility below.

http://www.primopdf.com/


Mike

 

[Barb Reinhardt]

Take a look at Ron DeBruin's site. He's got some good info there.

http://www.rondebruin.nl/pdf.htm

HTH,
Barb Reinhardt

 

[Jim Thomlinson]

Check out this link...

http://www.excelguru.ca/node/21

 

[Ron de Bruin]

FYI

I update the page yesterday with a new argument if you want to use a fixed file name.

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm