We help IT Professionals succeed at work.

What is the difference between VBA and VB.net?

JPiper44
JPiper44 asked
on

I am confused....what is the difference between VBA versus VB.net??
Comment
Watch Question

Expert of the Quarter 2010
Expert of the Year 2010
Commented:
http://en.wikipedia.org/wiki/Visual_Basic_for_Applications
http://en.wikipedia.org/wiki/Visual_Basic_.NET

VBA is a BASIC based (mainly) procedural language used to enhance functionality of (mostly) Microsoft Office applications.  It is not strongly typed and is interpreted, a scripting language.  Later version support code modules and classes, but it is quite slow.  The main intended use is for end users to be able to manipulate the Microsoft Office Applications and documents to provide even more functionality than out of the box.

VB.Net is Microsoft's latest implementation of the BASIC language to work on their .Net platform.  It is strongly typed, object oriented, compiles into MSIL and further machine code using NGEN or Just-in-time compilation.  It's intended use is to create full applications, for various platforms, web (ASP.Net, silverlight), mobile (Vb.net+.Net Compact Framework), Windows (.Net Winforms/WPF), Windows services etc.
you can create independent application using VBA. VBA is to enhance functionality like it is used for Macro,VBScript (.vbs).

VB.net is used for to create independent application and dll.