Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to catch the event when an Excel window gets focus?
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to catch the event when an Excel window gets focus?
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/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to catch the event when an Excel window gets focus?
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to catch the event when an Excel window gets focus?
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Catch column width event. | Excel Programming | |||
How do I 'catch' a 'delete cells' event | Excel Discussion (Misc queries) | |||
Catch drop event in excel | Excel Programming | |||
Excel Interop Catch Event for Saving a file as xls and as xml? | Excel Programming |