Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.vb.addins
|
|||
|
|||
Addin for Excel - general doubts
I have a basic c++ com based addin running inside excel already. But what i
dont know is how much of a latitude is the addin allowed while inside excel. IDTExtensibility2 defined a class(com) that can be created by excel. Whenever something interesting happens, excel calls one of its methods to tell the class something has happened. USUALLY it is here that class could do whatever it wants. Or rather the excel object structure implies so. But if you notice, from the addins side, it is just a class that is present in this equation. A class cant execute instructions by itslef. So it is some EXCEL thread that has loaded the addin class and calling the class's method on its behalf. Now, if i were to start a timer from my classes loading routine, that would basically mean that i have a timer for that particular thread concerned. That would mean that i am messing around with one of excels threads. I dont want to do that. i dont know if it is ok to interrupt excel thread like this or in any other manner. can i ask Excel "please wake me up periodically so that i can do my work & not interrupt or break you in any way either" ? If there is no way to do the above mentioned thing, well the next option is probably to have a thread of my own. Then the problem becomes "how can i interrupt excel from this new thread" Well, i have an Application handle that my IDTExtensibility2 class was given when it was loaded by excel. I could use that to probe excel / temporarily ask excel to wait while i do something else / or simply raise an event that can be handled by the instance of my original addin class. (I think the last one is more clean and probable) I dont know if it is ok or thread safe to call into excel randomly (& rudely like this) using the app pointer. And even if it was thread safe i wouldnt know how to raise an event myself, intended for my com addin Or well, it is safe to do so, i could simply modify the cells contents myself from that thread - but i really dont think so. i have external events and i need to respond to them and make changes to excel. I cant use RTD or DDE because i wouldnt know in advance which cells to change. Or is there any other technology thats there suitable for this kind of situation ? Please suggest. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
xy chart doubts | New Users to Excel | |||
excel doubts | Excel Discussion (Misc queries) | |||
Microsoft Excel doubts | Excel Discussion (Misc queries) | |||
Two doubts for Macros | Excel Discussion (Misc queries) | |||
Remove Excel AddIn from AddIn List !! Help | Excel Programming |