|
|
- Part of the Visual Basic family
- Visual Basic, Visual Basic for Applications (VBA), and VBScript stem from the
same language - BASIC programming language (which is short for
'Beginner's All-purpose Symbolic Instruction Code') . In that way they have at least a fundamental
similarity.
- VBA is a hosted language, it provides an interface (or a glue) for accessing the host
application's objects
- Differences between VBA and VB
- The set of VBA objects available in each application is different
(see Example of VBA for Excel).
- VBA programs and the host application execute on the same process
space, whereas VB programs can be compiled into executable codes and
run in their own process space.
- VBA programs always need to be interpreted.
- Differences between VBA and VBScript
- VBScript is a scripting version of VB. There are some syntax
differences between VBScript and VBA. For example, VBScript does not allow you
to explicitly declare any data types, all variables are implicitly
Variant.
- VBScript is often used for the web programming (such as an asp
file) and for system administration (such as a vbs file).
- Differences between VBA and VB.NET
- VB.NET requires the .Net Framework.
- VB.NET is type safe, i.e.: no longer declaring variable as variant
types and assigning them any values.
- Every single thing in VB.NET is an object, even an integer is an
object. For example, you can use qty.ToString to convert the integer
qty into a text string, instead of using the Cstr() function.
|
|
