[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now


what is the main diffrences between vba and vb?

Posted on 2001-06-20
Medium Priority
Last Modified: 2010-05-02
HI to everybody,

i want to know main diffirences between vba and vb.
which one is more superior. as know vb is more but why?
i want to make prog with vba in autocad that's more appropiate or making object in vb for similar job.

Question by:nikelsh
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +2
LVL 15

Accepted Solution

lyonst earned 200 total points
ID: 6210480
Please read the full article...


Extract .

In its simplest form, Visual Basic for Applications is a glue language. This means that as a VB or VBA developer, you concentrate on the interface of and interaction between the objects and controls within the application, gluing the various elements of the application together by writing procedures to perform programmatic tasks and by adding code to handle events. Visual Basic programs are primarily event-driven. Some event or other - such as the user clicking a button - triggers most of the procedures you will write......


LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 6210495
VB can produce executable files (.exe), while VBA cannot, as VBA remains an interpreted language.
Interpreted language means that there is a "host" application that is reading the VB(A) code, and executing it line per line.
VB programs are independant in the sense that they only have a (large) runtime dll that is needed to "translate" all the API calls...

Besides this, VB code is richer, and VBA code has some restrictions compared to pure VB. Also, VB can be faster, as it is not interpreted in .exe mode.

Now for your last question (VB or VBA for the autocad project):
It depends on many factors, and maybe the best could be a mixed solution. It depends mostly on the technical details of your project.

LVL 15

Expert Comment

ID: 6210498
For Autocad this might help.


Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Expert Comment

by:Valliappan AN
ID: 6211015
LVL 22

Expert Comment

ID: 6211189
I finally came to the recognition that "VBA" is the actual Basic language library and interpreter.  In reality, this is the Basic virtual machine, and is applied to a variety of applications including Visual Basic.

I describe it as follows:

VBA for Word is the programming language for Word.  It knows how Word works because of the Word object library and talks to Word in its own language.

VBA for Excel is the programming language for Excel.  It knows how Excel works because of the Excel object library and talks to Excel in its own language.

VB is really VBA for Windows.  i.e. A programming language for Windows.  It knows how Windows works because of the Windows API and talks to Windows in its own language.

Proof that the VB tool is really VBA for Windows:  Look under project|references and what do you see as the first entry?

(And as someone pointed out, the VB environment also knows how to build a standalone version of itself--an .exe)

Author Comment

ID: 6212871
Thanks to everybody,

lyonest your answer almost stysified me. Anglellll and rspahitz also given answer with up to mark but here i can accept answer only one that's not fare i think.

anyway good job keep it up.


Expert Comment

by:Valliappan AN
ID: 6212923

>here i can accept answer only one that's not fare i think.

if you wsih to give points to others, you could do by just posting a question each, with title like 'points to so and so' and they need to put a comment and you accept that as answer, thats it. You could see like this, in some questions in EE, only to give points.


Author Comment

ID: 6217983
thanks valli


Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question