By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,699 Members | 1,209 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,699 IT Pros & Developers. It's quick & easy.

Excel automation in VB.net

P: n/a
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
Nov 21 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Once you import the Excel library and constants you can pretty much take
macro code right out of the VBA Editor and paste it into VB.NET. How far
have you gotten? The first thing to do is add a reference (under COM) to
the Excel library, not sure which one you want to use XP or 2000.

--
W.G. Ryan MVP Windows - Embedded

Have an opinion on the effectiveness of Microsoft Embedded newsgroups?
Let Microsoft know!
https://www.windowsembeddedeval.com/...ity/newsgroups
"KC" <yo*@dontneed.this> wrote in message
news:OP**************@TK2MSFTNGP15.phx.gbl...
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

Nov 21 '05 #2

P: n/a
Have you seen
http://support.microsoft.com/default...&Product=vbNET

--

HTH

Éric Moreau, MCSD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Concept S2i inc.(www.s2i.com)
"KC" <yo*@dontneed.this> wrote in message
news:OP**************@TK2MSFTNGP15.phx.gbl...
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

Nov 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.