Hello, I want to open all excel files in a folder on SharePoint that include the words "Detail Form" in the filename. I can get my code to work if I hard-code the filenames, but the wildcard isn't working. Here is what I'm trying to use right now:

wbname = "http://durham-intranet:8080/sites/budget/Dept Budget Contacts/FY12 Budget/" & DeptFolder & "/" & "*" & "Detail Form.xlsm"
The DeptFolder variable works, but as soon as I add a wildcard instead of the full filename, I get errors.

Thanks in advance for your help.