View Single Post
  #2 (permalink)  
Old November 26th, 2007, 12:55 PM
allenm allenm is offline
Friend of Wrox
Points: 513, Level: 8
Points: 513, Level: 8 Points: 513, Level: 8 Points: 513, Level: 8
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Feb 2007
Location: Davenport, IA, USA.
Posts: 163
Thanks: 0
Thanked 2 Times in 2 Posts

1) If you're only going to code macros then it is far cheaper to go with VBA... it comes with MS Office and is a little easier to learn / use with office. If you wish do do more coding than just office macros then you will probably want to invest in Visual Studio. Some coding experience will transfer between VBA and the VB code in Visual Studio, but Visual Studio is a full coding environment platform meant to code desktop applications. The learning curve is much steeper due to it's greater versatility.

2) Visual Studio will not necessarily help you in use of Excel (any flavor). VBA code will because it only works within MS Office. So to code VBA you will have MS Excel open. VBA also gives you a greater understanding on how Excel works because it deals mostly with manipulation of data and ranges within Excel. Visual Studio doesn't focus solely on Office so would be less advantageous to learning Excel.

3) Not all Excel 2007 VBA will necessarily work for previous versions. Understanding that, most of the code will translate without need to recode any of it. If you program a VBA macro in previous versions of Excel then they almost always (No, not always, there are always exceptions) work with newer versions. The primary reason why Excel 2007 code might not work with an earlier version is if you use newer syntax or object(s) not available in previous versions.

Hope this helped.

Reply With Quote