look at the help on the filesearch object. You could trigger that on the
worksheet_change event, testing for the entry cell. Then if it is found,
open it.

You can also use Dir or the scripting runtime library (filesystem object).
Having all files in a single directory would make things simpler, but isn't
essential.

--
Regards,

Tom Ogilvy


"Brad" wrote in message
...
Hello,

What I am looking to do is give the end-user an option to open a file by
typing in the file name in a specific cell (say b10:) My end-users deal with
creating and referencing contracts. So, if they need to open a contract, all
they would have to do is type in the contract # (which is the file name) and
have it opened. Is this possible to do with a user-form or somehow create a
macro from this. All the contracts are located on a share drive, but they
are saved in different folders. Is it possible to have the macro search all
folders for this file or would they all have to be under one folder?