Excel VBA to print a chart as a pdf file
 

I want to print a chart to a pdf file when the file is
opened. I am using Excel 2000. I have Acrobat installed
on my computer. I tried using a macro to write the VBA
for me, but the recorder (when you go back to edit the VBA
code) does not captture the "Save PDF File As"
information. Any help would be appreciated.

Excel VBA to print a chart as a pdf file
 

Looks like two people tried to help you.

--
Regards,
Tom Ogilvy

"Golf Club" wrote in message
...
I want to print a chart to a pdf file when the file is
opened. I am using Excel 2000. I have Acrobat installed
on my computer. I tried using a macro to write the VBA
for me, but the recorder (when you go back to edit the VBA
code) does not captture the "Save PDF File As"
information. Any help would be appreciated.