How do I update methods and properties in VBA?
Visual Basic
1
Posts
1
Posters
0
Views
1
Watching
-
I have written an MFC ActiveX control in VC++7 and am testing it in Excel 2000. For some reason Excel will not recognize any methods of the control that were added to the control after the very first time I used it in Excel. Even in a completely new spreadsheet. The new methods show in the object browser of Excel/vba but generate a "runtime error 438 (Object doesn't support this property or method)" error when called in the vba code. I've tried unregistering the control, removing it physically, removing references to it but all to no avail. If I try all of the above in Access 2000 using VBA it works fine. Is this an Excel bug of some kind or...?