Amend message box text to include current Month and Year

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.

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

Once saved the following message is displayed i.e.

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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

Fluff13,


EXCELLENT, Exactly what I wanted !!

Many thanks


Regards


Rob