Need help - macro to save file. Path and filename in cells

[namuser]

Hi,


I'm very new to this so I would really appreciate your help on this matter.


I have an excel database, column A with employee names and Column B with supervisor


name. I would like to build a macro which will save a specific file (called "template.xlsx")


in a folder named as Column B (supervisor name). The filename should be employee name


(Column A).


Values from column B are build as path_to_file/test/supervisor_name.

 

[mtharnden]

you can save a file according to the values of cells easily.
this code will save IF the folders already exist if not youll need to add something that would check for the folder, if it does not exist will create it. if you google that or search here you will find a lot.

basically, you set a value for the supervisor and employee names and use those in your filepath when you save. this is just a little scratch to get you started, what i set the names to i am asuming you do not want to just use the first employee, but hopefully you can get that where you want.

Sub savefile()

    Dim SupName As String
    Dim EmpName As String
    
    SupName = Range("B2")
    EmpName = Range("A2")

    ActiveWorkbook.SaveAs Filename:= _
        "path_to_file\test\" & SupName & "\" & EmpName & ".xlsx" _
        , FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False

End Sub

 

[Memon]

as mtharnden said the code will help you