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 tried using a macro to
write the VBA for me, but the recorder does not capture
the "Save PDF File As" information. Any help would be
appreciated.

Excel VBA to print a chart as a pdf file
 

Hi
you need a 'pdf printer' to be able to print a chart as pdf format.
e.g., Adobe Acrobat

--
Regards
Frank Kabel
Frankfurt, Germany


Golf Club wrote:
I want to print a chart to a pdf file when the file is
opened. I am using Excel 2000. I tried using a macro to
write the VBA for me, but the recorder does not capture
the "Save PDF File As" information. Any help would be
appreciated.

Excel VBA to print a chart as a pdf file
 

First you need a pdf printer driver.

Then in VBA
' store your active printer
StrActivePrinter = Application.ActivePrinter

' activa your pdf like this
Application.ActivePrinter = "Adobe PDF op Ne05:"

' and setting your printer back
Application.ActivePrinter = StrActivePrinter

For the right name of the PDF printer you can record a macro puch CRTL+P
select by the printer your pdf driver, then cancel

I hope that will help you trough your problem
"Golf Club" schreef in bericht
...
I want to print a chart to a pdf file when the file is
opened. I am using Excel 2000. I tried using a macro to
write the VBA for me, but the recorder does not capture
the "Save PDF File As" information. Any help would be
appreciated.