Adding a prompt to an existing Macro

[RamseyMN]

Hello -

I currently have a macro set up that takes one very large Excel with about 200 tabs and separates it into multiple Excel's and saves them all out to a folder. I will be running this Macro each month and would like it to change the name of the document to include the month that it is related to. For example, right now the Macro will save a document as "Ramsey Summary.xlsx" and I would like the Macro to automatically add "JAN14" at the end. I would like this to be dynamic so each month, I would like it to prompt me and I can enter the appropriate month, year combo (i.e. FEB14, MAR14). I use Excel 2010.

Any ideas on if this is possible and if so, how to set it up. I am looking for an effecient solution as the large file separates into about 50 different files and would rather not manually input the month/year into each file.

Any ideas or thought would be greatly appreciated!

 

[John Davis]

Does this help?

Sub RamseyMN()
ActiveWorkbook.SaveAs "Ramsey Summary " & Format(DateAdd("m", 0, Date), "mmmyy") & ".xlsx"
End Sub

 

[RamseyMN]

That worked! Thank you so much!

Does this help?

Sub RamseyMN()
ActiveWorkbook.SaveAs "Ramsey Summary " & Format(DateAdd("m", 0, Date), "mmmyy") & ".xlsx"
End Sub

 

[John Davis]

You're welcome. Glad to help out and thanks for the feedback.