I have one workbook that has a Workbook_Resize event macro in its ThisWorkbook module. The workbook has an AutoOpen macro that among other things sets a public/global variable - Filename - to the value of ThisWorkbook(). E.g. File.xlsm.
As a matter of procedure and knowing that my macros...