Reference documentation for automating Excel form .NET

[dpdg]

I've been having to do a lot of automation of Excel spreadsheets from .NET and I get information from about everywhere I can find it. There doesn't seem to be any complete documentation on the subject. About the best I have been able to find is on Microsoft's site. But there are still a lot of other things that I need to be able to figure out.

Does anyone know of a good complete reference book or somewhere on line that I could find some good documentation on this?

Someone said that VBA is good for that, but is it the same in dot net?

 

[chiph]

To automated Excel just add a reference to the primary interop assemblies (comes with Office Tools for .NET), then make call pretty much like you would under COM.

So, to learn how to automate Excel in .NET, pick up any Office VBA book. The actual syntax of the code you write will be in VB.NET, but all the method names will be identical.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first