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.
Sub SaveAppSubmit()
Dim SaveName As String
SaveName = ActiveSheet.Range("B28").Text
ActiveWorkbook.SaveAs filename:="D:DocumentsNew" & _
SaveName & ".xlsx"
End Sub
Hi Sherry,
Instead of SaveAs, use SaveCopyAs, will leave the current workbook intact.
@Catalin Bombea,
Such a simple subtle difference is the answer. Thanks so much. I was so close, but just could not see it! Thanks again for your assistance!
