| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| print all worksheets of Excel file to one pdf file | Excel Discussion (Misc queries) | |||
| my excel is converting all my print jobs to print to file why? | Excel Discussion (Misc queries) | |||
| How do I print from a file created from sending a print to a file | Excel Discussion (Misc queries) | |||
| my Excel chart doesn't print as it appears on print preview | Excel Discussion (Misc queries) | |||
| FILE Save As / FILE Print greyed out in Excel | Excel Programming | |||
Linear Mode
