Printing Graphs in pfd

[Capaez2]

I have a Excel workbook to produce and print a lot of graphs (Excel 2003).

The workbook uses a Graph template and changing the data in the template allow to print all the graphs. This is done with a Macro.

When trying to print using the printer option "Adobe pdf" to produce graphs in pdf format a screen pront appears asking for a file name, this file name need to be inputted manually.

I wolud like to input the pdf file name automatically in the macro.

Is this possible?

 

[crimson_b1ade]

Hi Capaez2, not directly since Adode is not part any office object models. But you can probably do it indirectly. My PDF printer usually auto fills in the name of the file with the Excel book name. Therefore, using vba you should be able to save your workbook to whatever file name you want the pdf to be in then kill the dupe file afterwards.

Hope this gives you some insight.

 

[yytsunamiyy]

Or you could investigate "sendkeys". I haven't worked with it myself yet, so I can't give you any tip on how to implement it, but I know it is a way of communicating from vba to non-office programs.

 

[Capaez2]

Hi Capaez2, not directly since Adode is not part any office object models. But you can probably do it indirectly. My PDF printer usually auto fills in the name of the file with the Excel book name. Therefore, using vba you should be able to save your workbook to whatever file name you want the pdf to be in then kill the dupe file afterwards.

Hope this gives you some insight.

Thank you, I will try this

 

[Capaez2]

Thank you, I will look into it.

 

[Capaez2]

Or you could investigate "sendkeys". I haven't worked with it myself yet, so I can't give you any tip on how to implement it, but I know it is a way of communicating from vba to non-office programs.

!This actually worked!
The command "sendkeys" is a somehow tricky to use. It has to be allocate above the printing instruction.