MS Excel, VB6 and VB.Net

[TheRobster]

Hi all,

I'm learning VB.Net 2003 at the moment as part of a university course, mainly because I want to write some applications for the work I'm doing. I also want to create some spreadsheets to automate a lot of tasks that would otherwise be a pain in the ass to do by hand. To this end I want to program Excel using the built-in VB functions.

The only thing is, I haven't used VB before so VB.Net 2003 is my first experience of this language. As far as I'm aware, the VB in Excel is a cut-down version of VB6? If so then will the things I learn relating to VB.Net 2003 still be applicable to the version of VB in Excel?

Also, will I be able to write applications in VB.Net 2003 and link them to Excel spreadsheets if Excel is still only using an older version of VB?

Apologies if I have all the above wrong! I am not sure how VB works in Excel exactly.

Cheers
-Rob

[RobDog888]

VBA is practically the same as VB. VB .NET is a horse of a different
color. Have you heard of VS Tools for Office 2003? If your
using .NET then this would be the way to go for Office program
automation, assuming that you have Office 2003. I am still
learning it too. After its installed it adds new icons in the VS IDE
project selector. Basically you get a template to work from like
other vb projects.

HTH

[TheRobster]

I'm actually using Office XP. Does this have VS Tools compatability as well?

Cheers
-Rob

[RobDog888]

Sadly I haven't come accross anything yet, as the title suggests -
VS Tools for Office 2003. Office 2003 is written using .NET that s
where the compatibility comes from.