In VBA, Automation Error (440) occurs when you try to access the automation objects (objects that are used by other applications or programming tools). It’s a run time error that can occur while running a code. As Microsoft says that, there could be the following reasons that can make this error occurs:
- When you let an applicaton access an object from Excel or to create an object that can be used with the Excel and while using a method or a property with that object this error can occurs.
- Or you are trying to use an error that has been blocked or diabled by the system administrator.
How to Deal with Automation Error
The best way to deal with the automation error is to use the “On Error Resume Next” statement that moves to the next line of the code irrespective of the error. You can also use the Err object to get information about the source and nature of the error.
More on VBA Errors
Subscript Out of Range (Error 9) | Type Mismatch (Error 13) | Runtime (Error 1004) | Object Required (Error 424) | Out of Memory (Error 7) | Object Doesn’t Support this Property or Method (Error 438) | Invalid Procedure Call Or Argument (Error 5) | Overflow (Error 6) | VBA Error 400