Thread
:
Micro that checks if file exists
View Single Post
#
9
pete
Posts: n/a
Hi Veljo,
I used Bob's suggestion,
1.
On Errror Resume Next
Set nextFile = Workbooks.Open("filename")
On error Goto 0
This portion will get rid of the irritation "run-time error".
2.
If Not nextFile Is Nothing Then
...... begin your code
Else
End If
Reply With Quote