Macros do not work when file name is changed

[mthomas57]

Hello all this is Mike

I want to use a "template" file named CALC_Letter_Matrix_TEMP.xlsm. The macros work fine is this file. An MS Access database is using this template file and changes the name to a permanent file name with a date stamp in the file name. When I open the saved file the macros do not work. The "Template" file has the macros set to "All Open Workbooks". Am I missing something?

Also users use the saved file and are on a shared network.

Below is my references to the workbook so nothing is hard-coded to a specific file name.

Thanks so much for your help.


Code:
WSName = ActiveSheet.Name
Set ws = ThisWorkbook.Worksheets(WSName)

'Path to same file
FilePath = Application.ActiveWorkbook.FullName

 

[mthomas57]

Not sure why but it's working now. If anyone has an idea why it might have not worked at first please feel free to enlighten me. Thanks again so much!