Macro to save xls to pdf with path & naming convention

Hello,

I am using the below macro to save my workbook with in the correct path and naming convention.

In fact, as I also need a pdf file from that excel file, I tried to change the below macro and replace ".xlsm" by ".pdf"... However acrobat does not like it..

HTML Code: 

I guess that I should use the print option which gives me that when I record the macro. However I have no clue how to implement my naming convention + path in that macro.

HTML Code: 

Can you please help??

Many thanks,
Graig

Hi,

read VBA help of ExportAsFixedFormat method …

Perfect ! Thanks.