hello - what I want to do is have VBA code find a filename, open it, and then copy part of a spreadsheet into the existing open spreadsheet. The problem is, I want to use a wildcard in the Path name.
Example: I want to open a file "g:\admin\1234_Client Name\2015PlanSpecs.xls"
1234 is defined by a variable called "ClientNumber"
Client Name is where I want to put the wildcard. The client can be identified by it's number, and I don't want the user to have to input the plan name as well. As long as a wildcard is only in the filename, it works, but I can't get it to work with a wildcard in the path. Can someone help?