Macro to save the excel sheet to PDF
 

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.

Macro to save the excel sheet to PDF
 

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


"Neil Holden" wrote:

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.

Macro to save the excel sheet to PDF
 

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

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

HTH,
Barb Reinhardt

"Neil Holden" wrote:

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.

Macro to save the excel sheet to PDF
 

Check out this link...

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

Jim Thomlinson


"Neil Holden" wrote:

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.

Macro to save the excel sheet to PDF
 

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




"Barb Reinhardt" wrote in message
...
Take a look at Ron DeBruin's site. He's got some good info there.

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

HTH,
Barb Reinhardt

"Neil Holden" wrote:

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.