Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Posts
    43

    Unanswered: VB - VBA - Difference?

    I realise what the acronyms stand for-but whats the difference in the real world?

    Or is VB just a shortened way of writing\saying VBA?

    Sorry i realsie this question is a total idiots question-but we all start somewhere.........

  2. #2
    Join Date
    Sep 2003
    Location
    Cincinnati, Oh USA
    Posts
    203

    Re: VB - VBA - Difference?

    VBA = Can't compile and run as 'stand alone'
    Originally posted by Oliver_No1
    I realise what the acronyms stand for-but whats the difference in the real world?

    Or is VB just a shortened way of writing\saying VBA?

    Sorry i realsie this question is a total idiots question-but we all start somewhere.........
    Rick Knight
    KnightShift Office Solutions and Horse Breaking
    VB, VBA, FileMaker, Access Solutions, Web Solutions

  3. #3
    Join Date
    Feb 2004
    Posts
    43
    As opposed to VB which can stand alone?

    Thanks.

  4. #4
    Join Date
    Sep 2003
    Location
    Cincinnati, Oh USA
    Posts
    203
    Yes, VBA was specificly designed to bring VB functions into the Microsoft Office products. Because VBA runs with these applications they are part of the application and can not be compiled into a stand alone app.

    Originally posted by Oliver_No1
    As opposed to VB which can stand alone?

    Thanks.
    Rick Knight
    KnightShift Office Solutions and Horse Breaking
    VB, VBA, FileMaker, Access Solutions, Web Solutions

  5. #5
    Join Date
    Oct 2003
    Posts
    706
    As noted, the languages are essentially the same. The VB product includes a compiler, but only after a manner of speaking... the compiled programs still rely very much on outside support.

    No matter what you do with it, VBA is still Basic. (Well, the folks at Dartmouth University would disagree...) It's good for scripting and it gets a lot of use there; Microsoft has certainly made a mint from it. But it has severe limitations for larger projects. Stay within its scope and you're fine; march too far out of it and the language won't go along with you.
    ChimneySweep(R): fast, automatic
    table repair at a click of the
    mouse! http://www.sundialservices.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •