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.

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" <(E-Mail Removed)> wrote in message
news:86527596-01C4-485E-92AA-(E-Mail Removed)...
> 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.

There are 3rd party tools that do this, but I can't locate an API in
my brief search. AUTOMATE does it, but it's not free.

www.NetworkAutomation.com/AutoMate/

Have a look at this:

http://groups.google.com/group/micro...8d1026e3dd6667

http://groups.google.com/groups/sear...ion+Gets+Focus