Issue a name to an Excel file in a Macro

[jacarter]

I've created a timesheet for myself with a macro to update information in it. Now, my boss wants me to make one for the rest of my team.

My timesheet is named JAC04.xls. For me to create one for each member of the team I will need to change the Macro. For example, from JAC04.xls to SLK04.xls.

Is there a way to issue a name for the active file (or window) similar to the way I did it for the active cell as follows:

' Remember where you were:
ActiveCell.Name = "BEGIN"

This way I won't have to edit the Macros for all of the team members and edit the Macro every year.

 

[Joe4]

You mean like:

MyFile = ActiveWorkbook.Name

You can then activate it later by using:

Windows(MyFile).Activate

 

[jacarter]

Thanks Mr. Fisherman!