Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > Beginning VB 6
Password Reminder
Register
Register | FAQ | Members List | Calendar | 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 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 Display Modes
  #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!




Reply With Quote
  #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
Default

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.)
Reply With Quote
Reply


Thread Tools
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 --- 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 03:12 PM
visual studio for ms office dartcoach Access 2 June 17th, 2005 03:38 PM
Visual Studio Tools for Office Arsi VS.NET 2002/2003 0 September 23rd, 2004 08:04 PM



All times are GMT -4. The time now is 05:02 PM.


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