View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RobFMS RobFMS is offline
external usenet poster
 
Posts: 4
Default Excel automation in VB.net

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

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
"KC" wrote in message
...
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