Hi,
I'm looking for recommendations on which language I should focus on learning.
Like everyone here, I done a variety of Excel VBA "projects" throughout the years. Instead of starting from scratch each time, I want to start building tools that I can repeatedly use and add to. My focus is on Excel and Word, but I don't want to limited myself just to those.
Question 1: What is the best way to create portable toolsets? Should I be creating classes? In the past I've created bunches of functions that I move with me -- but I've found that in the end I just re-create everything.
Question 2: Should I focus on learning VBA, VB6, VB.NET, or something else. Coming from more traditional languages (C/C++) I find VBA very constraining. Maybe I just need to really learn VBA?
Question 3: What's the best IDE to use. Should I use VBA editor in Excel, Visual Studio Express, or Visual Studio 2010 (which I get through work).
Thanks for your help!
Matt
I'm looking for recommendations on which language I should focus on learning.
Like everyone here, I done a variety of Excel VBA "projects" throughout the years. Instead of starting from scratch each time, I want to start building tools that I can repeatedly use and add to. My focus is on Excel and Word, but I don't want to limited myself just to those.
Question 1: What is the best way to create portable toolsets? Should I be creating classes? In the past I've created bunches of functions that I move with me -- but I've found that in the end I just re-create everything.
Question 2: Should I focus on learning VBA, VB6, VB.NET, or something else. Coming from more traditional languages (C/C++) I find VBA very constraining. Maybe I just need to really learn VBA?
Question 3: What's the best IDE to use. Should I use VBA editor in Excel, Visual Studio Express, or Visual Studio 2010 (which I get through work).
Thanks for your help!
Matt
