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.
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.