Thanks - that makes sense to an extent and solves a part of the problem
My major problem, though, is still activating the exact workbook fro
the 100 or so that are open.

When I open the "S:\names" file this has a list of partial names i
cells a1 down to a100

for instance it may, in cell a1, say "mlud" - This would be th
potential start of a file name such as "mlud.xls" that is open - bu
may not be the active workbook at the moment. So I'm trying t
reference the fact that mlud relates to "mlud.xls" - but for som
reason it doesn't seem to pick up that fact when I use

If WB.Name Like ActiveCell.Value then
WB.Activate

where the 'ActiveCell.Value' for the cell a1 in the workbook name
would be "mlud"

I really appreciate the help already given and any further assistanc
in trying to work out where I'm going wrong with the above

thanks. joe

--
jlejeha
-----------------------------------------------------------------------
jlejehan's Profile: http://www.excelforum.com/member.php...fo&userid=3395
View this thread: http://www.excelforum.com/showthread.php?threadid=53833