View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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.