How to catch the event when an Excel window gets focus?
Andrew,
From a VBA point of view, there is no exposed event that tells you this.
Solutions include using a timer to check the window with focus or
subclassing for the appropriate message.
I can't say if there is anything available from a .Net/COM addin
perspective.
NickHK
"Andrew" wrote in message
...
Hello, friends,
I am using Excel in our C#.net applicaiton. I need to catch the events
when
the launced Excel window gets focus. I tried
AppEvents_WorkbookActivateEventHandler
AppEvents_WindowActivateEventHandler
It worked fine when more than one .xls files were opened and I switched
between those Excel windows. However, it did not worked when there was
only
one open .xls file and I switeched between this Excel window and other
apps,
for example, after using IE, I came back to the Excel, non of the above
events fired.
How to get around this problem since I really need to catch this event?
Any
ideas?
Thanks a lot.
|