Solved

what is the main diffrences between vba and vb?

Posted on 2001-06-20
8
290 Views
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.

nikelsh
0
Comment
Question by:nikelsh
  • 2
  • 2
  • 2
  • +2
8 Comments
 
LVL 15

Accepted Solution

by:
lyonst earned 50 total points
Comment Utility
Please read the full article...

http://www.oreilly.com/catalog/vbanut/chapter/ch02.html

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......

Cheers,

T.
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
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.

Cheers
0
 
LVL 15

Expert Comment

by:lyonst
Comment Utility
For Autocad this might help.

http://www.autodesk.com/develop/devres/oem/q3.htm

T.
0
 
LVL 9

Expert Comment

by:Valliappan AN
Comment Utility
ping..
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 22

Expert Comment

by:rspahitz
Comment Utility
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)
0
 
LVL 1

Author Comment

by:nikelsh
Comment Utility
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.

nikelsh
 
0
 
LVL 9

Expert Comment

by:Valliappan AN
Comment Utility
nikelsh,

>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.

Cheers.
0
 
LVL 1

Author Comment

by:nikelsh
Comment Utility
thanks valli

nikelsh
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

763 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now