Im trying to write a c# application that can receive data from an excel spreadsheet each time the data in certain cells in the spreadsheet are changed.
Ive done this in previous versions of Excel and VC++ using DDE and OLE but Im a bit lost with C#, .NET and Excel XP. (Also its a number of years since I worked on those projects so I cant remember what I did)
Ive tried adding the Excel OLE object to the references in the project and have a bunch of Excel objects but cant find the relevant documentation to these objects. Also Im not sure if this is the best way to proceed. ie OLE
As a second price (if I cant receive "change/data" notifications in a C# application) I could of course put a timer in the C# app to query the values/status in the Excel cells so any info or pointers in the right direction here would also be much appreciated.
Many thanks,
Cathy
Ive done this in previous versions of Excel and VC++ using DDE and OLE but Im a bit lost with C#, .NET and Excel XP. (Also its a number of years since I worked on those projects so I cant remember what I did)
Ive tried adding the Excel OLE object to the references in the project and have a bunch of Excel objects but cant find the relevant documentation to these objects. Also Im not sure if this is the best way to proceed. ie OLE
As a second price (if I cant receive "change/data" notifications in a C# application) I could of course put a timer in the C# app to query the values/status in the Excel cells so any info or pointers in the right direction here would also be much appreciated.
Many thanks,
Cathy