VBA - Open file with wildcard in path

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?

Please Login or Register  to view this content.

Thanks.

I get an error on the "With" statement. I get "Compile Error: Sub or Function not defined"

With CreateObject("Shell.application")
Set ASCpath = .Namespace("G:\admin\")
Endwith

Thanks.

I get an error on the "With" statement. I get "Compile Error: Sub or Function not defined"

With CreateObject("Shell.application")
Set ASCpath = .Namespace("G:\admin\")
Endwith

Also, if you could explain what the 32 means in "Folders.filter 32" that would be great.
Thanks.