Mike,
I don't use .net language, but you need Interop etc
AFAIK.
Here's a start :
http://support.microsoft.com/kb/301982
NickHK
"Mike" wrote in message
...
I'm not familiar with Automation. If you could give me just a few more
words, I could start Googlin'.
thanks
"NickHK" wrote in message
...
Mike,
Since you can't get the HWnd, SendMessage is useless.
Can you not use Automation to control Excel ?
NickHK
"Mike" wrote in message
...
I can send a message to a dotNet Textbox and have it trigger the
TextBox_Change event. What I want to do is the reverse. I want to send
a
message from dotNet to Excel VBA and have it trigger some event so I
can
immediately respond to the event. Since I can't get a Handle for any of
the
VBA controls, I'm not having much luck. I can send a message that
changes
the Form Caption but this doesn't trigger any event that I can find,
and
I
want to stay away from a polling technique.
Any ideas would be appreciated.
mike