View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matthew Connor Matthew Connor is offline
external usenet poster
 
Posts: 17
Default 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