VB.net and VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is VBA wholly and completely a subset of VB.net? Are there any objects or
methods or coding techniques that one could learn in VBA that wouldn't also
apply in VB.net?

So if I will have learned VB.net, by definition, I will have learned VBA?
 
VBA is not a subset of VB.NET in the first place. VBA applications are not
managed code (do not run within the CLR).

VBA uses the Visual Basic 6.0 (COM based) programming language in
conjunction with Office application object models. If you learn/know VBA,
you will have learned "some" of the VB.NET language syntax, but you will not
have learned any of the object oriented techniques used in VB.NET and you
will not have worked with the .NET Framework Class Libraries.

The short answer is VBA and VB.NET are 2 very different and unrelated
things.
 
Thank you.

Scott M. said:
VBA is not a subset of VB.NET in the first place. VBA applications are not
managed code (do not run within the CLR).

VBA uses the Visual Basic 6.0 (COM based) programming language in
conjunction with Office application object models. If you learn/know VBA,
you will have learned "some" of the VB.NET language syntax, but you will not
have learned any of the object oriented techniques used in VB.NET and you
will not have worked with the .NET Framework Class Libraries.

The short answer is VBA and VB.NET are 2 very different and unrelated
things.
Click to expand...
 
DKJ,

In addition to Scott,

VBA and VBS you can see to VB6 and VBNet as
JavaScript and JScript to Java and CSharp.

It uses the same style and keywords

Cor
 
Back
Top