Visual Basic for Applications Reference

  • Article

Automation error (Error 440)

See Also    Specifics

When you access Automation objects, specific types of errors can occur. This error has the following cause and solution:

  • An error occurred while executing a method or getting or setting a property of an object variable. The error was reported by the application that created the object.

    Check the properties of the Err object to determine the source and nature of the error. Also try using the On Error Resume Next statement immediately before the accessing statement, and then check for errors immediately following the accessing statement.

For additional information, select the item in question and press F1.