how to handle events of workbooks in com -addin..

[S Pammar]

Hi,

I am writing a COM addin in C++ for Excel. I want to perform some actions on
events like Sheet Change, SheetActivate, Workbook_BeforeClose,
RightMouseclick, etc. How to do this using C++ ? any small sample would be
helpful.

Thanks a lot,
Pammar

 

[Wei-Dong Xu [MSFT]]

Hi Pammar,

Based on my experience, I'd suggest two KB articles below will help you a lot on this issue. Please go to:
230689 SAMPLE: Comaddin.exe Office 2000 COM Add-In Written in Visual C++
http://support.microsoft.com/?id=230689

309301 HOW TO: Handle Events for Excel by Using Visual C++ .NET
http://support.microsoft.com/?id=309301

If you use Visual Studio 6.0, this KB article Q186427 will provide some assistance as well. Plesae go to:
186427 HOWTO: Catch Microsoft Excel Application Events Using VC++
http://support.microsoft.com/?id=186427

Please feel free to let me know if you have any further questions.

Does this answer your question? Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------