C#: Excel 2007 Addin, How to Hook Windows Activate and Deactivate Events

Posted by user127490 on Stack Overflow See other posts from Stack Overflow or by user127490
Published on 2009-07-03T12:36:35Z Indexed on 2010/03/27 21:03 UTC
Read the original article Hit count: 669

Filed under:

addins

|

hooks

|

dllimport

|

excel-vba

I am writing an Excel 2007 Addin. using VS2008 and .net 3.5, C#.

I catched Microsoft.Office.Interop.Excel.Application's WindowActivate and WindowDeActivate events.

It was surprised 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. same way from notepad if i switch to excel window, i expect Activate to be triggered but its not happening. It looks like the behaviour indicates windows are MDI-Child windows.

Now what i want to do is get HWnd of Excel's Mainwindow and hook Window Activate and Deactivates using dllimport features.

Can anyone guide to me on this.

Regards

© Stack Overflow or respective owner

Related posts about addins

where to download Virtual PC addins?

as seen on Server Fault - Search for 'Server Fault'
Hello everyone, I am using Virtual PC 2007 on Windows Vista Enterprise x86. I need Virtual PC addins to enable functions like shared folder between host and guest OS. But I am very surprised I can not find a download URL from search. Could anyone point me to the download URL for my platform please… >>> More
Syntax Highlighting VS Addins

as seen on Stack Overflow - Search for 'Stack Overflow'
What tools are out there that compete with this product? CodeKana I know ReSharper has improved syntax highlighting. Is it comparable to this? >>> More
addins deployment

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello Everyone, we have a product that work as standalone and Clickonce , we created some components as addins in the system (based on microsoft System.addin) we need a mechanism to update this addins on the customers in the two cases stand and click once I'm thinking for the stand alone we just… >>> More
Test Strategy for Addins

as seen on Stack Overflow - Search for 'Stack Overflow'
I was wondering if someone from the forum, can help me in uderstanding the type of Testing that will be performed, I mean a Test Strategy, we need to test things like Add-ins. Also need to know how can I reply to the person who has replied to my question, I kow its a bit not so mature quesiton, but… >>> More
Office Interop addins installer?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have three C# Solutions in Visual Stuido 2008, one each for Word, Excel and PowerPoint using interop to hook various events. In each Solution, I have exactly one class, the one created by default when using File - New - Project - Visual C# - Office - 2007. Now that I have my addins working properly… >>> More

Related posts about hooks

Documentation for Liferay Hooks

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi there, I need to listen for user log in and log out events in Liferay. From what little I've been able to find, it seems that using Liferay hooks would be the way to accomplish this. Unfortunately I haven't been able to find any information other that at the following link: http://www.liferay… >>> More
Easy way to set up global API hooks

as seen on Internet.com - Search for 'Internet.com'
Discover an easy way to set up system-wide global API hooks using AppInit_DLLs registry key for DLL injection and Mhook library for API hooking. To illustrate this technique we will show how to easily hide calc.exe from the list of running processes. >>> More
Adding hooks to TortoiseHg

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using TortoiseHg and would like to apply a hook to my repo. My repo's .hg/hgrc file is as follows: [hooks] pretxncommit = python:hg_checksize.newbinsize The thing is that I don't know where TortoiseHg's PYTHONPATH variable is set. How do I change it? Or where do I put my Python file so… >>> More
gitosis-admin git push failed, exec hooks/post-update

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm following this tutorial http://scie.nti.st/2007/11/14/hosting-git-repositories-the-easy-and-secure-way after this step git commit -a -m "Allow jdoe write access to free_monkey" git push i always failed, with this error fatal: exec hooks/post-update failed. this is from my /home/git/repositories/gitosis-admin/hooks/post-update -rwxr-xr-x… >>> More
Hooks...exactly what they are

as seen on Stack Overflow - Search for 'Stack Overflow'
I have seen hooks in Kohana PHP framework, and they work as some sort of a callback function triggered by a certain event (Kohana's events that is, some sort of method overloading). I have seen hooks in Wordpress, and I don't know what they are or how to use them (just saw them yesterday). I'm looking… >>> More