Quote:
If the file is being used by another process, would this cause an issue?
Well ... this code:
On Error GoTo ErrorHandler
...
ErrorHandler:
Return False
Would mean that if the file was in use, it would return false - so anything which means it can't complete the task would get you a "random" "no match" signal.
But please, forget "On Error ..." completely, and use Try ... Catch blocks. They will give you a lot better info as to what happened to cause the problem as part of the Exception object, and that would mean that tracking down exactly why it's a problem should be a load easier.
Since it's intermittent, I'd probably start by checking the same file for equality: if that ever fails, it's not the file itself that is causing the problem...