View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default 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.