What is VBA?

Dear Friends
                       
Can anyone explain these things
What is VBA?
What is the difference b/w VBA & VB ?
Is VBA and  vbscript is same?


Regards
Prakash


LVL 10
prakash_prkAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
GrahamSkanConnect With a Mentor RetiredCommented:
VBA is visual basic for applications. It cannot be used to produce compiled programs, and can only be used from the particular application that hosts it
The language (syntax) is the same.
0
 
Arthur_WoodConnect With a Mentor Commented:
VBA is Visual Basic For Applications, and is a 'version' of Visual Basic that is used (and licensed by Microsoft) to program other applications (MS Access, MS Word, Lotus Notes, PowerPoint, AutoCad to name a few).  It is a programming language closely related to Visual Basic, with some platform specific limitations and/or features.

VBA is NOT the same as VBScript

AW
0
 
prakash_prkAuthor Commented:

Where i can write the code?
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
GrahamSkanRetiredCommented:
VBScript is a freestanding uncompiled language and requires a 'host' to interprete it.
It's language is very similar to VB and VBA, but there are important differences.
0
 
GrahamSkanRetiredCommented:
You write VBA code in Word, Access, Excel or other Microsoft Office applications.

It can be incorporated into third party-applications as well, but I don't know of an example
0
 
bkthompson2112Commented:
You can access the VBA editor from Excel, Access, etc.
by pressing <Alt><F11>
0
 
GrahamSkanRetiredCommented:
Arthur,
I don't know about Autocad, but Lotus Notes uses LotusScript, which resembles VB(A), but is not the Microsoft product.
0
 
prakash_prkAuthor Commented:

Is a macro written in MS Excel is VBA ?
0
 
Joachim CarreinConnect With a Mentor Sr. Software DeveloperCommented:
yes it is
0
 
Arthur_WoodCommented:
LotusScript is Lotus' licensced version of VBA - Microsoft licenses VBA to other vendors so they don't need to 're-invent the wheel'.  Lotus then 'renames' it as LotusScript - makes them feel better I guess.

AW
0
All Courses

From novice to tech pro — start learning today.