Returning character if file is in a 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
jcdowning@comcast.net

[Ivan F Moala]

Hi John, welcome to the board

Here is one way.....

Function IsFile(strFilePath As String) As String

application.volitile
If Len(Dir(strFilePath)) = 0 Then
    IsFile = "Whatever"
Else
    IsFile = "File present"
End If

End Function

so in a cell formula would be

=IsFile("c:\a\test.xls")