ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel automation in VB.net (https://www.excelbanter.com/excel-programming/311884-excel-automation-vbulletin-net.html)

KC[_4_]

Excel automation in VB.net
 
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

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






All times are GMT +1. The time now is 07:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com