ActiveX registering problem with VBA
 

"Chris Lardi" wrote in message
...
I'm developing an ActiveX control using MFC and have a problem when
using my control in a VBA project. While developing the control I
decided to test it in Excel. When using a "User form" in a VBA project,
I can add my control to the control pallet and then place it on my form.
When I double-click it, VBA generates a handler for the Error event and
takes me to the code. From here I can select other events to handle from
a list. However, VBA shows the events from a previous version of my
control. It does not show any new events and the parameter list for some
events are inconsistent with the current version of my control. Why is
this?

VBA caches the type library of the control in a file with .oca
extension. Unregister the control, find and delete this file, and
register the control again.
--
With best wishes,
Igor Tandetnik

"For every complex problem, there is a solution that is simple, neat,
and wrong." H.L. Mencken