Excel uses VBA to determine whether a file exists

First, through fileexists to determine whether the file exists

Dim MyFile as Object

Set MyFile = CreateObject ("Scripting.FileSystemObject")

If myfile.fileexists ("e:dzwebspiclogo.gif") = True Then

MsgBox "File exists"

Else

MsgBox "file does not exist"

End If

The above code is used in a VBA environment. Or it can be made into a macro. "E:dzwebspiclogo.gif" is a file path and file name that can be modified by itself.

Second, by Dir to judge

Dim Youfile as String

Youfile = Dir ("E:mypicturespiclogo.gif")

If x <> "" Then

MsgBox "File exists"

Else

MsgBox "file does not exist"

Endif

"E:mypicturespiclogo.gif" is a file path and file name that can be modified by itself. Of course, as on the code, also used under VBA, you can become a macro or a function can be.