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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Arthur_WoodCommented:
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
GrahamSkanRetiredCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
prakash_prkAuthor Commented:

Where i can write the code?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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 CarreinSr. 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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.