I dont know how to get wildcards into a workbook..

[CALCO2023]

Hi.. recorded a macro and now working to get bugs out. I have a workbook that opens with sequential numbers on the end of the name and want to use a wildcard in place of that number..

AS IS
Windows("Warehouse Pick Priority (3).xlsx").Activate

NOT WORKING
Windows("Warehouse Pick Priority (*).xlsx").Activate


Seems like I should be able to use a wildcard to activate my other workbook.. Skipped over this issue and the forum has been very helpful but having problems with this one issue.

 

[dreid1011]

If it still is the case where one cannot open a workbook using asterisk as a wildcard, then please read this: Using a wildcard to open an excel workbook