Best to add a UDF
Function BookExists(wb As String)
BookExists = Len(Dir(wb)) 0
End Function
and use like
=IF(BookExists("C:\myfile.xls"), "yes","no")
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Arien" wrote in message
...
I would like to make a True/False statement in an excel-formula that
checks
if a certain file exists on the harddisk or not.
There must be some kind of VBA statement for that.
Please let me know if you can help me. Thanks.
Arien de Haan
Eindhoven, NL
--
Arien
------------------------------------------------------------------------
Arien's Profile:
http://www.excelforum.com/member.php...fo&userid=1892
View this thread: http://www.excelforum.com/showthread...hreadid=497521