Change CSActiveX Property

May 29, 2009 at 6:40 AM


many projects in codefx are very useful for me. I have one question related to the csactivex-subproject : After i used the ActiveX-Control in MS Excel, i was never able to change/add the properties (so, that Excel notify the changes). MS Excel do not update the changes in the Control. I have the same effect in all other Office Products - after i insert the ActiveX-Control in a MS Office Product, i cant ever see modified / added properties for THIS MS Office Product. Unregister und Register (regasm) has no effect. Searching the Property in registry has no results.

Did anyone knows this effect ?

May 30, 2009 at 10:59 AM
Edited May 30, 2009 at 11:00 AM

Hello swe

First of all, thank you very much for liking the codefx project!

I have tested the scenario in your description and can reproduce the problem. My first reflection was that Excel caches the first load of the ActiveX control. I thus used the sysinternals tool, process explorer, to view the file handles of the Excel process. Process Explorer shew this file which caught my eyes: C:\Users\Jialiang Ge\AppData\Local\Temp\Excel8.0\CSActiveX.exd. I deleted the file and restarted Excel, new properties were then recognized.

Some relevant KB articles:

Jialiang Ge

Jun 3, 2009 at 6:59 PM

thank you for answer,

yesterday i found another solution. I have to increase Assembly- and Fileversion, than Office seems to recognize the changes in the properties. But for develpoment, i will delete the .exd files.




Jun 4, 2009 at 12:24 PM

Thank you, SWE!

I will document this into the ReadMe.txt file of CSActiveX and VBActiveX.

Jialiang Ge