Hello Everyone,
I am leveraging a Macro to create PDF for my file. Currently, I am using following code to create PDF Output:
This saves PDF name as "ABC Royalties 2022_w_XYZ meter data & DEF meter data". I want to have a PDF Output name as "ABC Royalties "Billing_Month"_w_XYZ meter data & DEF meter data"
where as Billing_Month is a Name I have defined in my excel and is referenced to a field. is it possible to do that ?
Thanks for your help in Advance.
Ali
I am leveraging a Macro to create PDF for my file. Currently, I am using following code to create PDF Output:
Sub Summary_PDF_Print()
'
' Summary_Print Macro
'
'
ActiveSheet.ExportAsFixedFormat _
Type:=xlTypePDF, _
Filename:=ActiveWorkbook.Path & "\" & "ABC Royalties 2022_w_XYZ meter data & DEF meter data", _
Quality:=xlQualityStandard, _
IncludeDocProperties:=False, _
IgnorePrintAreas:=False, _
From:=1, _
To:=5, _
OpenAfterPublish:=True
End Sub
This saves PDF name as "ABC Royalties 2022_w_XYZ meter data & DEF meter data". I want to have a PDF Output name as "ABC Royalties "Billing_Month"_w_XYZ meter data & DEF meter data"
where as Billing_Month is a Name I have defined in my excel and is referenced to a field. is it possible to do that ?
Thanks for your help in Advance.
Ali