Using Wildcard on Workbooks.Open
I want to use a wildcard on the Workbooks.Open command, but it doesn't
recognize the wilcard character as being a wildcard but part of the filename.
I'm concatenating two string variables into the filename. Any idea if this
will work?
Code:
Workbooks.Open Filename:="\\Yucca\" & Name1 & "_" & Name2 & "*.xls"
|