checking for existence of file

[gtrp]

hi

I want to get my macro to check for the existence of a file - File 1 - in a folder - folder 1.
If the file is found then the macro should attempt to open it, otherwise it will bypass that and move on to the next step.

any ideas?

Thanks!

G

 

[Norie]

The Dir function returns an empty string if the file is not found.

So you could use it like this

If Dir(C:\Folder1\File1.xls) <>"" Then
' carry out code to open file
End If

 

[gtrp]

thanks a lot!!



G