View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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.