Hello everyone,
I have this macro that takes the text from specific cells and makes it the title of the excel workbook. However, I can't seem to get around telling it to save to the same directory it's in. Because in a certain folder on the computer I open which is called Master, for example. I have quite a few macros in it. My idea is to save this same file (so as not to lose the macros) but already with a new title. Save As..... - I change the name, I already have things written inside, I have a new file and everything is in it. The Master file remains, waiting to be reopened and new information written.
I would appreciate any help from you. It is very important that it automatically goes to the folder, and not for me to give it, write a directory.....
    Sub SaveAsA1()
ThisFile = Range("J1").Value & " " & Range("C2").Value & " " & Range("B4").Value & " " & Range("A4").Value
ActiveWorkbook.SaveAs fileName:=ThisFile
Application.GetSaveAsFilename
End Sub