| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unexpected Behaviour of _ExcelObject_WindowDeactivate
Hi I am writing an Excel Addin. using VS2008 and .net 3.5 I traped following events _ExcelObject.WindowActivate += new Microsoft.Office.Interop.Excel.AppEvents_WindowAct ivateEventHandler(_ExcelObject_WindowActivate); _ExcelObject.WindowDeactivate += new Microsoft.Office.Interop.Excel.AppEvents_WindowDea ctivateEventHandler(_ExcelObject_WindowDeactivate) ; It was surprized to know that WindowActivate and Deactivate only triggers when i switch between two excel windows. if i switch to notepad, i expect Deactivate to be triggered, but its not happening. sameway from notepad if i switch to excel window, i expect Activate to be tiggered but its not happening. This is quite annoying. Anyone knows the reason and correct way to handle it ? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Unexpected Behaviour of _ExcelObject_WindowDeactivate
Hi Jignesh --Window Activate and Deactivate events are similar to MDI child window activate/deactivate OR in other words events within one windows application/one Process ID. --What you are looking of is active Application. The GetForegroundWindow function in .NET returns a handle to the foreground window Refer http://msdn.microsoft.com/en-us/libr...05(VS.85).aspx If this post helps click Yes --------------- Jacob Skaria "JIGNESH" wrote: Hi I am writing an Excel Addin. using VS2008 and .net 3.5 I traped following events _ExcelObject.WindowActivate += new Microsoft.Office.Interop.Excel.AppEvents_WindowAct ivateEventHandler(_ExcelObject_WindowActivate); _ExcelObject.WindowDeactivate += new Microsoft.Office.Interop.Excel.AppEvents_WindowDea ctivateEventHandler(_ExcelObject_WindowDeactivate) ; It was surprized to know that WindowActivate and Deactivate only triggers when i switch between two excel windows. if i switch to notepad, i expect Deactivate to be triggered, but its not happening. sameway from notepad if i switch to excel window, i expect Activate to be tiggered but its not happening. This is quite annoying. Anyone knows the reason and correct way to handle it ? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Unexpected Behaviour of _ExcelObject_WindowDeactivate
Hi Jacob, I don;t prefer to use Windows API. is there a Add-in way to capture Activate and deactivate event of Excel Main/Parent MDI Window? Regards "Jacob Skaria" wrote: Hi Jignesh --Window Activate and Deactivate events are similar to MDI child window activate/deactivate OR in other words events within one windows application/one Process ID. --What you are looking of is active Application. The GetForegroundWindow function in .NET returns a handle to the foreground window Refer http://msdn.microsoft.com/en-us/libr...05(VS.85).aspx If this post helps click Yes --------------- Jacob Skaria "JIGNESH" wrote: Hi I am writing an Excel Addin. using VS2008 and .net 3.5 I traped following events _ExcelObject.WindowActivate += new Microsoft.Office.Interop.Excel.AppEvents_WindowAct ivateEventHandler(_ExcelObject_WindowActivate); _ExcelObject.WindowDeactivate += new Microsoft.Office.Interop.Excel.AppEvents_WindowDea ctivateEventHandler(_ExcelObject_WindowDeactivate) ; It was surprized to know that WindowActivate and Deactivate only triggers when i switch between two excel windows. if i switch to notepad, i expect Deactivate to be triggered, but its not happening. sameway from notepad if i switch to excel window, i expect Activate to be tiggered but its not happening. This is quite annoying. Anyone knows the reason and correct way to handle it ? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Unexpected Behaviour of _ExcelObject_WindowDeactivate
Application.Hwnd returns a Long indicating the top-level window handle of the Microsoft Excel window. Or try Application.WindowState If this post helps click Yes --------------- Jacob Skaria "JIGNESH" wrote: Hi Jacob, I don;t prefer to use Windows API. is there a Add-in way to capture Activate and deactivate event of Excel Main/Parent MDI Window? Regards "Jacob Skaria" wrote: Hi Jignesh --Window Activate and Deactivate events are similar to MDI child window activate/deactivate OR in other words events within one windows application/one Process ID. --What you are looking of is active Application. The GetForegroundWindow function in .NET returns a handle to the foreground window Refer http://msdn.microsoft.com/en-us/libr...05(VS.85).aspx If this post helps click Yes --------------- Jacob Skaria "JIGNESH" wrote: Hi I am writing an Excel Addin. using VS2008 and .net 3.5 I traped following events _ExcelObject.WindowActivate += new Microsoft.Office.Interop.Excel.AppEvents_WindowAct ivateEventHandler(_ExcelObject_WindowActivate); _ExcelObject.WindowDeactivate += new Microsoft.Office.Interop.Excel.AppEvents_WindowDea ctivateEventHandler(_ExcelObject_WindowDeactivate) ; It was surprized to know that WindowActivate and Deactivate only triggers when i switch between two excel windows. if i switch to notepad, i expect Deactivate to be triggered, but its not happening. sameway from notepad if i switch to excel window, i expect Activate to be tiggered but its not happening. This is quite annoying. Anyone knows the reason and correct way to handle it ? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Unexpected Behaviour of _ExcelObject_WindowDeactivate
Hi Jacob
Application.WindowState only has 3 state, Maximize, Minimize and Normal. Where as what i am looking at is WindowActivate and WindowDeActivate states. I think i will go with Application.Hwnd. Now what do i do with it? I understand idllimport stuff. need calling of WinAPI using but i hav't use it before. Can you help with an code example or discuss the steps in sequence (The API i need to call to hook Activate and Deactivate Events ) Regards Thanks for help so far. "Jacob Skaria" wrote: Application.Hwnd returns a Long indicating the top-level window handle of the Microsoft Excel window. Or try Application.WindowState If this post helps click Yes --------------- Jacob Skaria "JIGNESH" wrote: Hi Jacob, I don;t prefer to use Windows API. is there a Add-in way to capture Activate and deactivate event of Excel Main/Parent MDI Window? Regards "Jacob Skaria" wrote: Hi Jignesh --Window Activate and Deactivate events are similar to MDI child window activate/deactivate OR in other words events within one windows application/one Process ID. --What you are looking of is active Application. The GetForegroundWindow function in .NET returns a handle to the foreground window Refer http://msdn.microsoft.com/en-us/libr...05(VS.85).aspx If this post helps click Yes --------------- Jacob Skaria "JIGNESH" wrote: Hi I am writing an Excel Addin. using VS2008 and .net 3.5 I traped following events _ExcelObject.WindowActivate += new Microsoft.Office.Interop.Excel.AppEvents_WindowAct ivateEventHandler(_ExcelObject_WindowActivate); _ExcelObject.WindowDeactivate += new Microsoft.Office.Interop.Excel.AppEvents_WindowDea ctivateEventHandler(_ExcelObject_WindowDeactivate) ; It was surprized to know that WindowActivate and Deactivate only triggers when i switch between two excel windows. if i switch to notepad, i expect Deactivate to be triggered, but its not happening. sameway from notepad if i switch to excel window, i expect Activate to be tiggered but its not happening. This is quite annoying. Anyone knows the reason and correct way to handle it ? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Unexpected Behaviour of _ExcelObject_WindowDeactivate
Check out the below link http://www.mvps.org/access/api/api0034.htm If this post helps click Yes --------------- Jacob Skaria "JIGNESH" wrote: Hi Jacob Application.WindowState only has 3 state, Maximize, Minimize and Normal. Where as what i am looking at is WindowActivate and WindowDeActivate states. I think i will go with Application.Hwnd. Now what do i do with it? I understand idllimport stuff. need calling of WinAPI using but i hav't use it before. Can you help with an code example or discuss the steps in sequence (The API i need to call to hook Activate and Deactivate Events ) Regards Thanks for help so far. "Jacob Skaria" wrote: Application.Hwnd returns a Long indicating the top-level window handle of the Microsoft Excel window. Or try Application.WindowState If this post helps click Yes --------------- Jacob Skaria "JIGNESH" wrote: Hi Jacob, I don;t prefer to use Windows API. is there a Add-in way to capture Activate and deactivate event of Excel Main/Parent MDI Window? Regards "Jacob Skaria" wrote: Hi Jignesh --Window Activate and Deactivate events are similar to MDI child window activate/deactivate OR in other words events within one windows application/one Process ID. --What you are looking of is active Application. The GetForegroundWindow function in .NET returns a handle to the foreground window Refer http://msdn.microsoft.com/en-us/libr...05(VS.85).aspx If this post helps click Yes --------------- Jacob Skaria "JIGNESH" wrote: Hi I am writing an Excel Addin. using VS2008 and .net 3.5 I traped following events _ExcelObject.WindowActivate += new Microsoft.Office.Interop.Excel.AppEvents_WindowAct ivateEventHandler(_ExcelObject_WindowActivate); _ExcelObject.WindowDeactivate += new Microsoft.Office.Interop.Excel.AppEvents_WindowDea ctivateEventHandler(_ExcelObject_WindowDeactivate) ; It was surprized to know that WindowActivate and Deactivate only triggers when i switch between two excel windows. if i switch to notepad, i expect Deactivate to be triggered, but its not happening. sameway from notepad if i switch to excel window, i expect Activate to be tiggered but its not happening. This is quite annoying. Anyone knows the reason and correct way to handle it ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unexpected Result | Excel Worksheet Functions | |||
| A unexpected behavior | New Users to Excel | |||
| Unexpected (?) behaviour of OFFSET() in array formulas | Excel Discussion (Misc queries) | |||
| Workbook on intranet unexpected behaviour | Excel Programming | |||
Hybrid Mode
