Link to home
Start Free TrialLog in
Avatar of prakash_prk
prakash_prkFlag for India

asked on

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


SOLUTION
Avatar of Arthur_Wood
Arthur_Wood
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of GrahamSkan
GrahamSkan
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of prakash_prk

ASKER


Where i can write the code?
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.
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
Avatar of bkthompson2112
bkthompson2112

You can access the VBA editor from Excel, Access, etc.
by pressing <Alt><F11>
Arthur,
I don't know about Autocad, but Lotus Notes uses LotusScript, which resembles VB(A), but is not the Microsoft product.

Is a macro written in MS Excel is VBA ?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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