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