Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old November 18th, 2007, 04:46 PM
Registered User
 
Join Date: Nov 2007
Location: , , Canada.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default VBA vs. Visual Studio --- which is better?

Hi all,
First, my apologies if this is not the right forum..

I am using my spare time to learn how to create macros (for the first time) in Excel and Powerpoint in order to the use the programs more efficiently (since I spend way too much time on the them :)

I am SOOOO confused as to what the scoop is with VBA vs. VB net vs Visual Studios? Is there an expert that can provide me with some guidance given that:
--> I am new to programming and only intend to learn code in order to create macros in Excel & Powerpoint

Here are my questions:
1) Which programming language should I invest my time to learn if you were in my situation? This is complicated by the fact that most corporations do are not using Office 2007 and (from my experience) are utilzing Excel 2003
2) If I choose to learn Visual Studio or VBA 2007, will my knowledge of the language enable me to use Excel 2003?
3) If I create a macro in (for eg.) excel 2007, will it run in excel 2003?

Thanks so much for your help!!!!!

Excel rocks!


Reply With Quote
  #2 (permalink)  
Old November 26th, 2007, 12:55 PM
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
Default

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
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA vs Visual Studio for Office lovNexcel Beginning VB 6 1 November 19th, 2007 12:32 PM
FTP in Visual Studio 2005 Pro (Visual Basic) shoopes VB How-To 1 June 29th, 2006 02:08 PM
Visual Studio 2003 vs. Visual Studio 2005 eitanbarazani C# 2005 4 May 9th, 2006 01:34 AM
Visual Studio .net2003 and Visual Studio 2005 Gert Visual C++ 1 January 24th, 2006 05:10 AM
Visual studio 6 or visual studio .NET chaitannyam Visual C++ 1 November 13th, 2005 09:26 AM



All times are GMT -4. The time now is 04:30 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.