Hi All,

I have the following UDF to check if a file exists:-

Function FileExists(fname) As Boolean

If Dir(fname) < "" Then _

FileExists = True _

Else FileExists = False





End Function



The problem is that it doesn't re-calculate when you press F9. You have to
go into the cell by pressing F2 in order for it to re-calculate.



Adding "Applicaiton.Volatile" doesn't seem to work either.



How do you work around this?



Ta



Andi