Locating file in another directory

[john-downing]

I am trying to convert a Lotus 123 function into an excel fomula. In
Lotus a fuction "@isfile" will go into another directory and determine
if a file is there and return a code. Is this a way that this can be
accomplished in excel?

Again, this is the requirement. I want to have a formula or function
that will go into another directory and determine if a pre-defined file
is locted there and return a character or code to the cell. It only
needs to do this when the file is opened.

Thank You

John
(e-mail address removed)