How to catch the event when an Excel window gets focus?

A

Andrew

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.
 
N

NickHK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make scroll bar permanently visible, Word 365 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Excel App gets focus 0
how to catch these events? 5
Excel 2007 Ribbon Will Not Re-Validate Unless Excel Window Has Focus 0
How to set focus on an ActiveX ListBox 7
Try Catch errors locking Excel 1
Create timeline with event being hyperlinks to documents on drive 1

Top