Does Word document exist?

Palmyra · Oct 31, 2007

Can I check for the existence of a unc path and document?

Thanks.

AnotherHiggins · Oct 31, 2007

I use this in Excel. I'm not a really Word guy, but it should be close, if it doesn't work right away:

Put this somewhere:

Code:

Function FileThere(FileName As String) As Boolean
     FileThere = (Dir(FileName) > "")
End Function

Then you can call that later, like this:

Code:

If FileThere(FilePathAndName) Then
    ...

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.