Hi - I'm automating Excel from IP, which has been a bit painful, but looks to be working now. One extra thing I'd like to do is to subscribe to a worksheet's change event.
This (http://support.microsoft.com/kb/302815/) is an article that does in C# essentially what I'd like to do in IP. I can construct an AppEvents_SheetChangeEventHandler delegate wrapped around a function, but I can't find the event to hook it up - there's no .Change event on the worksheet. Nosing around the Microsoft.Office.Interop.Excel namespace (the Excel object model documentation is pretty patchy, although I've looked there too), I can see a type called AppEvents_Event, which does seem to expose the events I want. But I can't work out how to instantiate it (or even whether I should be trying to), and trying to attach the delegate to the event on the type results in: >>> Excel.AppEvents_Event.SheetChange += Excel.AppEvents_SheetChangeEventHandler(func) Traceback (most recent call last): File , line 0, in <stdin>##165 StandardError: Non-static method requires a target. (Which is pretty clear.) I'm about to try following the example in C#, and hopefully I'll be able to work out what the C# code's doing differently. In the meantime, has anyone successfully consumed Excel (or any Office application) events in IronPython? Can anyone familiar with COM<->.NET interop see what I should be doing? Thanks, Christian -- Christian Muirhead Resolver Systems [EMAIL PROTECTED] Office address: 17a Clerkenwell Road, London EC1M 5RD, UK Registered address: 843 Finchley Road, London NW11 8NA, UK Resolver Systems Limited is registered in England and Wales as company number 5467329. VAT No. GB 893 5643 79 _______________________________________________ users mailing list [email protected] http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
