does a file exist

[Arien]

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

[Bob Phillips]

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[Peter Rooney]

Arien,

Here's some code I use to delete a dummy file from the C drive - I'm sure
you can adapt it to your needs.

Regards & happy New Year

Pete

If Dir("C:\Holidays+Training+Sickness Chart.xls") <> "" Then
Kill "C:\Holidays+Training+Sickness Chart.xls"
End If

"Arien" wrote:

>
> 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
>
>

[Arien]

It works. Thanks a lot.
regards, Arien de Haan

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>