After serious thinking SS wrote :
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

Why not have your VBA project prompt you for which file to open and set
a reference to it so your code knows which open workbook to work with.
It stands to reason that if you knew which file to open BEFORE opening
your VBA project file then you'd also know which file to select so your
project can open it for you!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc