VBA File Exist commands? 1

[bujin]

Is there such a thing? If not, how do I find out if a file exists using Visual Basic for Applications (in Excel)?

 

[bujin]

Never mind, I got it! I was thinking of Delphi (I think). Just use the Dir() command.

 

[Guest_imported]

You can also use Application.FileSearch, it depends which one you think is easier.

 

[bujin]

Well would you look at that! That's simplified the task ten-fold!

Thx Dark_Sun!

 

[Psychpt]

Dir is the vb way to test if a file or directory exists.

HTH

 

[JWhyte]

Or use Scripting.FileSystemObject.

i.e.

Dim FSO As FileSystemObject

Set FSO = New FileSystemObject

If FSO.FileExists(&quot;<path to file&quot;) Then
     ' Code on existence of file.
End If

HTH John Whyte
jwhyte@skipton.co.uk