Save As macro with path and filename from cells Excel

[gelu]

Hello everyone,

I wrote a save as macro:

' Save_As_Names_In_Cells Macro
'
ChDir "C:\MrExcel"
ActiveWorkbook.SaveAs Filename:="C:\MrExcel\Macros\Test.xlsm", FileFormat:= _
xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
End Sub

I do not know how to tell it to pick:
- the root from range A1= "C:\ " or else
- "MrExcel" from A2 (folder name)
- "Macros", from A3 (subfolder)
- "Test.xlsm" from A4 (filename and type)

... so that users can change root\directory\filename by editing cells A1:A4 of Sheet1

Also, the saved as file should remain open.

Help would be much appreciated.

Kind regards,

GT

 

[gelu]

Ok, Thank you!