Hi rowan,
I am working on this. The way i understand is, i have to put your code
on every file i am opening.
Is that correct?

If i am correct is there a way to, resume the next task, for the whole
macro,
instead of each task seperatly?

Thx for your input.
Dave
Rowan Wrote:
Try a variation of this:

Dim File1 As String
Dim FF1 As String

File1 = "C:/Temp/H73FJ.xls"

FF1 = Dir(File1)

If FF1 < "" Then
Workbooks.Open Filename:=File1
MsgBox "Do something"
Windows(FF1).Close
Else
MsgBox "File doesn't exist"
End If

Hope this helps
Rowan

Piranha wrote:
Hi,

Have a macro that opens some files one at a time, and does stuff.

If Excel can't find one of the files, it gets i get the VBA file not
found error
and the code will not continue.

I need the code to continue even if it cannot find one of the files,
with no errpr messages.

I've tried variations of "On Error Resume Next" & "On Error Goto
ErrorTrap" with no luck.

Sub start

get file do work

file missing

get file do work

get file do work

end sub

Ideas?




--
Piranha
------------------------------------------------------------------------
Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435
View this thread: http://www.excelforum.com/showthread...hreadid=467024