I've written some code for a report that is distributed to four different users. Three of them, and my own machine can run the report without a problem, but one gets an error message at the start of the macro. The full message is this:

Automation error (Error 440)

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 (in Windows) or HELP (on the Macintosh).


Here is a snippet of the code
Please Login or Register  to view this content.
I'm not doing error trapping and from a Google seach it appears that the problem may be in the closing of the file that I opened at the start of the macro. How can I fix this and any ideas why it runs without a hitch on four machines and fails on another?