Automation Error

[yankee428]

I have a user with 2 PC's, same profile. On one he can open a file with no errors. On the other, the auto_open kicks off an Automation Error and the file does not work properly. On the first PC I can compile the code no problem, but on the second he gets this Automation Error. We've created new build's and standard matching profiles and we still get this error. There is nothing that we can find special about the one PC that works.

If I comment out the code that kicks off the error, the error still comes up, just without marking a spot in the project.

I know we can just ghost the working PC, but I would like to have a better solution than that.

Any ideas?

 

[Richie(UK)]

Hi,

On the PC where the code fails open the VBE and look at the references for the workbook in question (Tools/References).

Are any marked as MISSING? If so, which ones?

 

[yankee428]

Sorry, should have included this in my orig post. There are no missing references.

 

[Richie(UK)]

Hi,

Can you give a more specific description of the error message received?

What is included within the workbook? Are there userforms? What sort of controls have been added to the userforms? What version of Excel?

The more info that you can provide the higher the chances of somebody being able to help.

 

[yankee428]

It's XP on XP and there was no problem before the migration. They used to be on 97 on NT. All the error said was Automation Error. There is no call that I can see to building an object for another application (word, access, etc).