I have a cell A2 that will have the month entered (JANUARY for example). Then C2 will have the year entered (2022 for example). I have a button that I want to assign a macro to do this for me. If possible, when the macro names the file I would like it to be in this format "ECITATIONS_01JAN_2022.xlsm" for the month of January. February would be "ECITATIONS_02FEB_2022.xlsm" and so on. Right now I have a VBA code that saves and names the file but not based on the value of cells. It just names it to what is in the code and also plugs in the current date.
ActiveWorkbook.SaveAs Filename:="C:\Users\Desktop\" _
& "ECITATIONS_" & Format(Now(), "MM-DD-YYYY") & ".xlsm"
Any help is appreciated. Thanks.
ActiveWorkbook.SaveAs Filename:="C:\Users\Desktop\" _
& "ECITATIONS_" & Format(Now(), "MM-DD-YYYY") & ".xlsm"
Any help is appreciated. Thanks.