Can someone help me find an Excel VBA solution to step through my open workbooks to find the one with a name (always) formatted as "mmm-dd (ddd) Data.xlsx", and return the name of that file?
I have 3 open workbooks and I need to find the file name of the one, for example, named "Jun-24 (Mon)...