add date+given text in the file name

Hello,

I would like to save a workbook (bigfile1.xls) with "_values only_ddmmmyyyy" text added to the name. (=the result should be a workbook called bigfile1_values only_ddmmmyyyy.xls)
I have the date in dd-mmm-yyyy format in sheet 'header', cell BK3 of workbook bigfile.xls.

What is the syntax for diong this please, added to the below?

ActiveWorkbook.SaveAs Filename:= _
"C:\....path\bigfile1.xls" _
, FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=True, CreateBackup:=False

Thank you!
Dora

You can try with:

Please Login or Register  to view this content.

Regards,
Antonio

Hi Dora C,

Or this

Please Login or Register  to view this content.

And I think you don.t need this part

Please Login or Register  to view this content.