Solved

what is the main diffrences between vba and vb?

Posted on 2001-06-20
8
291 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
ID: 6210480
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]
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.

Cheers
0
 
LVL 15

Expert Comment

by:lyonst
ID: 6210498
For Autocad this might help.

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

T.
0
 
LVL 9

Expert Comment

by:Valliappan AN
ID: 6211015
ping..
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 22

Expert Comment

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

Author Comment

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

nikelsh
 
0
 
LVL 9

Expert Comment

by:Valliappan AN
ID: 6212923
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
ID: 6217983
thanks valli

nikelsh
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

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…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
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…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

896 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

17 Experts available now in Live!

Get 1:1 Help Now