AUTOMATION ERROR (error 440)

[RJ1969]

After they updated the system this happen.

When I clicked the "debug" and it highlighted this:

frmInputs.Show

Please Login or Register  to view this content.

THEN when I click "helped" this what it said. What should I do because I don't understand what it said on the help.... please help.


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:

1.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.
2.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.

[BadlySpelledBuoy]

On the proviso the UserForm in question actually exists in the file, I would say it's highly unlikely that the frmInputs.Show line is the one actually causing the problem.
When you click Debug and it stops at that line, press F8 and it should carry on. Keep pressing F8 to step through the code line by line until the one that actually causes the problem shows up.

IF you need more help than that debugging it then attach a desensitised version of the file and we can look at it for you.

BSB

[RJ1969]

Here is the code that I have in the frminputs.

Please Login or Register  to view this content.

Thank you

[RJ1969]

When I click the debug it highlighted the "frmInput.Show"
then this one

Please Login or Register  to view this content.

then after this one:

Please Login or Register  to view this content.

[RJ1969]

Hi

I google and saw this:
"Error trapping is one of the best ways to solve this problem. You can use On Error Resume Next – or On Error GoTo Label – depending on your needs at the time. If you want the code to carry on running and ignore the error, use On Error Resume Next. If you want the code to stop running, create an error label and direct the code to that error label by using On Error GoTo label."

Where do I add in the code "On Error Resume Next."


Thanks.

[RJ1969]

Here is the sample file.
After they upraded the system from 32 to 64bit... they some of my macro stop working or getting errors.

Please help. Thanks in advance.