Define PDF export name

[iepofanof]

Hi All,

I use the following (part of the) VBA code to define the name of the pdf file i'm exporting.

Please Login or Register  to view this content.

I want to remove the code that uses the filename of the excelfile and use a generic name instead (for example: "Orderconfirmation" & "_" & ActiveSheet.Range("N11") etc etc. )
Is there a way to do this?

Thanks!

[iepofanof]

Full code here;

Please Login or Register  to view this content.

[iepofanof]

Hi There,
Can someone help with this code?

[bakerman2]

Use this to define the name. Change D:\ to path to suit.

Please Login or Register  to view this content.

Adapt this to retrieve the attachment.

Please Login or Register  to view this content.