![]() |
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 |
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