Consuming excel events in C#
 

dansan wrote:
Hello all!

I have been trying to find documentation on how to consume events that
are generated by excel.

I have been playing around with a simple concept, to see if I can get
them to work. This is basically what I'm trying to do:

When a user clicks on a button on my windows form, the excel window is
raised. The user then goes and clicks on a cell, which triggers the
event. I can then have the address of the cell they clicked on and do
'some magic' with it then.

It seems pretty simple to me, but the solution is escaping me. I
haven't been able to find good doco for this stuff.

Thanks a ton.

Daniel.
I haven't used them myself, but I while ago I bookmarked the following
page:
http://msdn.microsoft.com/library/de...dc_oxppias.asp

It may not be exactly what you want; it is some documentation about
the Interop Assemblies that allow the unmanaged COM code (the Office
applications) to be more easily used in the .NET Framework.

Having only skimmed the document I don't know if they support the
consuming of events. I did pick up that only Office XP is supported.
IIRC, Office 2003 will be release with similar (if not better) support
for .NET.

Hope this helps,

Matthew

Consuming excel events in C#
 

It may not be exactly what you want; it is some documentation about
the Interop Assemblies that allow the unmanaged COM code (the Office
applications) to be more easily used in the .NET Framework.

Having only skimmed the document I don't know if they support the
consuming of events. I did pick up that only Office XP is supported.
IIRC, Office 2003 will be release with similar (if not better) support
for .NET.

Hope this helps,

Matthew


Thank you Matthew. I have read most of that documentation, and I have
been able to implement some stuff that talks with excel. The one
thing that I can't get it to do is consume events though.

Daniel.