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