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