Weird File Open Behavior After Windows 11 Upgrade

[Joe4]

I wrote some VBA code years ago for work that opens a bunch of files and runs some comparisons. The files have the same prefix every week, but different time stamps.
So this is the code the VBA code uses to open the files (first file):

    Dim fName As String
    fName = "C:\TEMP\Macros\Test\CMDB Server Report_*.xlsx"
    Workbooks.Open Filename:=fName

(I should note, that there will only ever be one file in the folder matching the desired prefix)

This has worked for them for years. Now, they have some updates they want me to make. When I try to run this code (which works for them) on my computer, I get the following error:

If I run this version of the code, with the exact file name, it works as expected.

    Dim fName As String
    fName = "C:\TEMP\Macros\Test\CMDB Server Report_20230901_0637.xlsx"
    Workbooks.Open Filename:=fName

however, since the date/time stamp changes every week, I cannot do that.

I don't understand why the original code is no longer working on my computer. The only thing of note I can think of is I upgraded to Windows 11 recently.
Perhaps some system setting changed, messing things up? Anyone have any ideas?

 

[JEC]

Pff ok, thanks for testing. Still weird

 

[Joe4]

Pff ok, thanks for testing. Still weird

Yeah, I agree.

It is weird that I did need to update the code to get the Excel files to work, but not the CSV files. They were all working the same way originally.
As long as everything works, I guess!

So the solution for this particular issue was a combination of 6StringJazzer's post (post #2) and Rory's post (post #5).

 

[6StringJazzer]

Dir onlly returns the file name, not path, so you should include the path in the Workbooks.Open with fName

Y'know, I forgot that but it worked just in my case probably because the folder the code was in was also the folder containing the file I was searching for. Poor testing.