Hello,

So far, I created a macro to save a Excel workbook with a specific name depending on the value entered in defined cells:

ActiveWorkbook.SaveAs _
Filename:=Application.GetSaveAsFilename(Range("B4") & " " & Range("B9") & " Form", _
FileFilter:="Excel File(*.xls),"), _
FileFormat:=xlNormal


Until here the macro works fine and correct.

However, I want to extend the macro that the file now gets automatically saved in a specific folder.

The path of the folder is as follow:
C:\Users\Stefan.Ahrendt\Desktop\DART\Client Approval\test.xls

Whereby, "test.xls" is the name of the file that I want to replace by the macro stated above.

Any advise how this can be done?

Thanks,