Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using Excel with automation | Excel Discussion (Misc queries) | |||
Excel automation | Excel Programming | |||
Ole automation with Excel 10 from Vb.net | Excel Programming | |||
Excel Com Automation | Excel Programming |