What Are the Differences Among Visual Basic, VBA, and VBScript?

Updated Nov 13, 2017

Reported In

Software

  • DIAdem 2014 Full
  • DIAdem 2015 Full
  • DIAdem 2017 Media

Issue Details

What are the differences among Visual Basic, VBA, and VBScript?

Solution

Visual Basic is a development tool for the production of code components such as executable programs, COM components*, or ActiveX controls. It is a complete development environment, comparable to Visual C++. 

VBA (Visual Basic for Applications) offers the same high performance tools as Visual Basic used within one Microsoft application to interact with another Microsoft application. VBA was initially an alternate programming choice for DIAdem (as opposed to VBScript). However, there were two substantial advantages to using VBScript over VBA:
- VBA was unnecessarily complex for the scripting tasks required. 
- Licensing costs for VBA were significantly higher.

For these reasons, DIAdem standardized on VBScript. 

VBScript is a "light-weight" sub-set of Visual Basic. DIAdem has the ability to develop and debug VBScripts through tools from Microsoft and an interface created by National Instruments.

* COM: (Component Object Model: Refers to a binary standard for independent and compatible software objects, so that the functions are available to a variety of different applications)

WAS THIS ARTICLE HELPFUL?

Not Helpful