Hi,

I’ve been kindly assisted in a previous post by (CK76 & Special-K) who kindly gave me the following code which appended the current month and year at the end of my file name when I save it i.e.

ActiveWorkbook.SaveAs Filename:=srcWB.Path & "\Response Document Stats (" & Format(Date, "mmmm yyyy") & ").xlsx", FileFormat:=51


Once saved the following message is displayed i.e.


MsgBox ("This Months ‘Response Document Stats' File Has Been Created And Save Successfully.")

Could anyone please advise me of the code I need to modify the message to also display the current month and year e.g.

This Months ‘Response Document Stats (March 2018).xlxs’ File Has Been Created And Save Successfully.

Any assistance would be greatly appreciated

Many thanks in advance

Regards

Rob