Automation Object 's method not be supported?

[cok]

Hi, all

I found a question about Excel 2003, I donn't know whether
it's my mistake.

I develope a Activex Control use ATL, begining, It's work good,
But after I change interface method name, build OK,

the new method name not recognized by VBA.
error code is '438'

why this error happened?

Can anyone give me advice?

thanks

 

[NickHK]

Can't say about ATL, but from a VB point of view it sounds like a binary
compatibility issue; you changed the interface, recompiled, new GUID.
So unregister the old control, register the new.
You can add to an interface without breaking compatibility, but not change
the signatures that already exist.

NickHK

 

[cok]

thanks to NickHK

I insert ActiveX control into excel work sheet using "Insert Object"
the generated name is Log1, when I use the new method of Log interface,
Error happened(438),

But using "Object browser", I found the interface type info was updated
already,

and I do these:
Set Log = CreateObject("ProgID")
Log.newmathod

these work successful,

why the Inserted ActiveX Control cann't work?
weather the Excel cache the Type Infomation of the Control ?
or other reason? , how can I fix this question?

thanks for your help