December 4, 2021
Macro needs some help. This macro works, but I want it to do one more thing. I have a button for it on my ribbon, as I use it often. I have a hard coded path for this macro, and the filename is in cell B28 of the file. What I want to accomplish is to save a COPY of the file with the file name in cell B28, and leave my template open, with no cells entered. I have done this before, but I cannot find the code. Can anyone help? Thanks in advance.
Dim SaveName As String
SaveName = ActiveSheet.Range("B28").Text
ActiveWorkbook.SaveAs filename:="D:\Documents\New\" & _
SaveName & ".xlsx"
November 8, 2013