My problem is trying to find the correct syntax to open a file where I know the filepath, but the file name is partial and part of that partial changes based on the date. So the file names look like this:
I want to open the excel file that has "new" in it, and corresponds to the date in my string currMonth (e.g. 20231114)
I want to open the excel file that has "new" in it, and corresponds to the date in my string currMonth (e.g. 20231114)