Change CSActiveX Property

May 29, 2009 at 7:40 AM

Hello,

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 ?

Coordinator
May 30, 2009 at 11:59 AM
Edited May 30, 2009 at 12:00 PM

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:

http://support.microsoft.com/kb/158875
http://support.microsoft.com/kb/199830

Regards,
Jialiang Ge

Jun 3, 2009 at 7: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.

Regards
SWE

 

 

Coordinator
Jun 4, 2009 at 1:24 PM

Thank you, SWE!

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

Thanks
Jialiang Ge