File exists on network?

Determines if a file exists anywhere on network.
Requires full path & filename
Author: michael@excelexperts.co.uk

Function fileExists(fname) As Boolean

    Dim x As String

    x = Dir(fname)

    If x <> "" Then
        fileExists = True
    Else
        fileExists = False
    End If

End Function

Address

Brookfield,
55 Heath Drive
Brookwood, Surrey
GU24 0HQ England

Scroll to Top