View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Trigger an Excel VBA event from another application

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