create macro for save as PDF
 

I'm trying to create a macro to save an Excel workbook (entire workbook) as
PDF. However, when I run the macro, it defaults to the original workbook
name, not the name of the new workbook. Is there some "wildcard" I can put
in the workbook name to default to the current name when saved? Thanks for
any help.

create macro for save as PDF
 

Hi cdumas

Not sure what you are looking for but I have info for 2007 here
http://www.rondebruin.nl/pdf.htm




--

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




"cdumas" wrote in message ...
I'm trying to create a macro to save an Excel workbook (entire workbook) as
PDF. However, when I run the macro, it defaults to the original workbook
name, not the name of the new workbook. Is there some "wildcard" I can put
in the workbook name to default to the current name when saved? Thanks for
any help.