Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > Beginning VB 6
| Search | Today's Posts | Mark Forums Read
Beginning VB 6 For coders who are new to Visual Basic, working in VB version 6 (not .NET).
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Beginning VB 6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old November 17th, 2007, 11:52 PM
Registered User
Join Date: Nov 2007
Location: , , Canada.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default VBA vs Visual Studio for Office

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

I just recently got laid off and I'm using some my time to learn how to create macros (for the first time) in Excel and Powerpoint in order to the use the programs more efficiently.

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?
2) Will this programming language be compatible to program macros in older / newer versions of excel / powerpoint?
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!

  #2 (permalink)  
Old November 19th, 2007, 12:32 PM
Friend of Wrox
Join Date: Nov 2004
Location: Port Orchard, WA, USA.
Posts: 1,621
Thanks: 1
Thanked 3 Times in 3 Posts

VBA is VB 6 is VBA. VB 6 is an implementation of VBA that allows you to create stand-alone programs with it, where as VBA on its own requires a host, (such as Word, Access, AutoCAD, etc.).

VB.NET is a major re-writing of VB. The changes are vast, even down to the general approches to everything.

The question is really not answerable. There are places that need full-time programmers to handle their implementations of Office products. There are places that need full-time programmers to handle their implementations of AutoCAD. But there are places that only hire .NET programmers. Yo uneed to figure out what you want to do, find out how the shops that do that are configured, and target that configuration.

Any programming you learn will be a case of learning good programming habits, or bad programming habits. If you do the former, you will have a much easier time adapting to some shhop or others needs.

I think the answer for # 3 is no. But you should be able to past the code out of the editor window into the editor window of the older version, and focus on correcting the syntax errors that are generated that way.

Excel is pretty good for what it is good for, but remember that it is not a relational database. (In fact, for the most part, it is not a database at all.)

Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA vs. Visual Studio --- which is better? lovNexcel Excel VBA 1 November 26th, 2007 12:55 PM
Visual Studio tools for office?? Medes Visual Studio 2005 1 April 10th, 2006 02:12 PM
visual studio for ms office dartcoach Access 2 June 17th, 2005 02:38 PM
Visual Studio Tools for Office Arsi VS.NET 2002/2003 0 September 23rd, 2004 07:04 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.