I'm doing a temp fix on an Excel-based system until I get
the .NET and connected version written. There is a
summarizer file that extracts data from a directory. I've
manually cleaned out non-compliant files. Now I want to
test for non-compliance in the VBA and perform some action
to correct the error (which works, btw).

The current flow has the "On Error GoTo BlahBlah" and when
I try to test and intercept the bad file to close and move
it, the error flag gets set to true and it goes to the
BlahBlah error code instead of performing my actions.

I've tried IsError, IsMissing, IsNull and the various
other IsProblem functions all of which return a TRUE which
exits the sub.

I don't want to rewrite all the error handlers for the 3
months it'll take to customize the new app. Any
suggestions for this VBA prob?

Thanks in advance,

E.