R
Robert
Hi everyone,
I've got a situation here that's rapidly driving me crazy:
An Excel 97 workbook contains several code modules and forms, and a
reference to an ActiveX-Control written in C. The control is then placed on
two of the forms.
Now, whenever I try to use or compile the worksheet code, I get an error
"Method or Data member not found" when trying to access a certain member of
the control library.
When I look into the object browser, I see that Excel seems to use a
stone-old version of the ActiveX-control. When I open a VB6 project, I can
see all the necessary members.
What did I try to resolve the problem?
Removed the controls from all forms
Remove the controls from the Workbook
Saved and closed the workbook
Deleted *.exd and *.oca on my computer
Verified that the control only has one CLSID in the registry, and that the
path given there was correct
Re-opened the workbook
Re-Added the control under "Additional controls" and to the forms
==> same result, and I have no idea why. How can excel even know the
interface for the old control version???
Help, please!
Robert
I've got a situation here that's rapidly driving me crazy:
An Excel 97 workbook contains several code modules and forms, and a
reference to an ActiveX-Control written in C. The control is then placed on
two of the forms.
Now, whenever I try to use or compile the worksheet code, I get an error
"Method or Data member not found" when trying to access a certain member of
the control library.
When I look into the object browser, I see that Excel seems to use a
stone-old version of the ActiveX-control. When I open a VB6 project, I can
see all the necessary members.
What did I try to resolve the problem?
Removed the controls from all forms
Remove the controls from the Workbook
Saved and closed the workbook
Deleted *.exd and *.oca on my computer
Verified that the control only has one CLSID in the registry, and that the
path given there was correct
Re-opened the workbook
Re-Added the control under "Additional controls" and to the forms
==> same result, and I have no idea why. How can excel even know the
interface for the old control version???
Help, please!
Robert