Automation Error

[manofprayer]

Can anyone help me with this error?

Class does not support Automation or does not support expected interface.

What does this mean?
What causes it?
What does can I do to remedy this?

[alex_read]

What's the lines of code you're getting this on?

[manofprayer]

That's my problem ... when I run it while I am testing it (meaning I run it in VB editor), I don't get any errors. But when I deploy it, that's the only time that the error occurs. So I don't t know what triggers the error. In my understanding interface is the header of a function for a class (or something like that) but I have no idea what class in my program or in what event this error occurs!

Any help would be most appreciated. Thank you.

[alex_read]

Have you got any references set from the project menu or activex controls in your app which you use?

To explain what's going on, lets say you use the Excel object library to write to & save a *.xls file from your code. You compile the app into an exe, then send it (on it's own without using a setup program) to another pc which doesn't have Excel installed.

As soon as you call the line set variablename = new Excel.Application, the code'll look for Excel in the registry, not find it & therefore won't be able to set the reference or start an instance of Excel up (which results in this error).

1) Are you using the P&D wizard o distribute your app.
2) If you use any ocx's or object library references in your code, try & run the regsvr32 program on the problem pc to register these classes.