使用Workbook。打开已知文件位置会导致“无法找到运行时错误1004 ”

I am building a utility to grab data from specific files and transfer that data to another file. The source files all have the same naming convention which includes an identical string that can be used to differentiate them from other files in a directory. The intent is to use that string with wildcards to open the file and pull the required data.I am building a utility to grab data from speci