(Solved) – Problem saving file using “save as” in VBA


I am trying to save my file name as the value in range(“A3”) in sheets(2) into one of my folders called “my assignment”. However, it does not save into folder instead it saves it on my desktop. Anybody knows where the issue is?

Btw “fab2crp-nas1home22kkang2ProfileDesktopmy assignment” refers to folder directory where i want to save it.

ActiveWorkbook.SaveAs Filename:="\fab2crp-nas1home22kkang2ProfileDesktopmy assignment" & ActiveWorkbook.Sheets(2).Range("A3").Value & "_Jramp" & ".xlsm", FileFormat:= _
 xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
 , CreateBackup:=False

Leave a Reply

Your email address will not be published. Required fields are marked *