Excel automation in VB.net

[KC]

Does anyone, anywhere, know of a link or something that explains Excel
automation in Vb.net? Specifically, details (hell, anything) on building a
chart from VB.net in Excel? I found some stuff on VB6, but the some of the
differences between that and .net are like night and day.

I can't believe how hard it is just trying to give the x and y axis names.
The help engine is useless - even though VB.net fully support this feature.
I think Microsoft inadvertently built these two things to work together and
no one has bothered to write it up.

Ken

 

[RobFMS]

Ken

Try turning on Macros and run the process in Excel first. Open the editor
and take a look at the code that was generated. This should give you a good
starting point.

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-