Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
switching workbooks using variable and wilcard filename
Hi,
Any help would be appreicated... I have a file open named: 203416 SS Mean Enzyme Activity Template.xls Then i open another file with all the vba. The operation in question needs to switch to the above file, but i only know the first six digit number, and can't be sure of anything else, except that it has the word Enzyme. The six digit number has already been defined as variable req1 so, in my file with macros, i try to switch to the correct open workbook using only req1 and Enzyme, but this doesn't work: Windows((req1) & "*Enzyme*.xls").Activate This does work, but i can't count on anything but the req1 number and Enzyme to be there every time: Windows((req1) & " SS Mean Enzyme Activity Template.xls").Activate I think it's just syntax... Thanks for any help, Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wilcard for Workbooks??? | Excel Programming | |||
switching between workbooks | Excel Programming | |||
Switching between Workbooks | Excel Discussion (Misc queries) | |||
Switching Between 2 workbooks using VBA | Excel Programming | |||
Converting a Variable Filename to a Constant Filename | Excel Programming |