VBScript Compared to VBA

While VBScript and Visual Basic for Applications (VBA) are similar and are both based on the Visual Basic standard language, there are advantages to using VBScript for IWS users:

VBScript is supported for the Microsoft Windows Embedded operating system, and VBA is not.
VBScript brings active scripting to a wide variety of environments, including Web client scripting in Microsoft Internet Explorer. This prevents operations that may present risks for the Thin Client user, such as direct access to local files.
VBScript was designed to be simple and easy to learn, with some standards from VBA modified in VBScript to make it more straightforward. For example, in VBScript the user does not have to worry about the type of each variable when declaring them because VBScript assumes the proper type for each variable automatically.

The following table lists VBScript features that VBA does not have.

Category	Feature/Keyword
Declarations	Class
Miscellaneous	Eval
Miscellaneous	Execute
Objects	RegExp
Script Engine Identification	ScriptEngine
	ScriptEngineBuildVersion
	ScriptEngineMajorVersion

The following table lists VBA features that VBScript does not have.

Category	Omitted Feature/Keyword
Array Handling	Option Base
Array Handling	Declaring arrays with lower bound <> 0
Collection	Add, Count, Item, Remove
Collection	Access to collections using ! character
Conditional Compilation	#Const
Conditional Compilation	#If...Then...#Else
Control Flow	DoEvents
	GoSub...Return, GoTo
	On Error GoTo
	On...GoSub, On...GoTo
	Line numbers, Line labels
Conversion	CVar, CVDate
Conversion	Str, Val
Data Types	All intrinsic data types except Variant
Data Types	Type...End Type
Date/Time	Date statement, Time statement
DDE	LinkExecute, LinkPoke, LinkRequest, LinkSend
Debugging	Debug.Print
Debugging	End, Stop
Declaration	Declare (for declaring DLLs)
	Optional
	ParamArray
	Static
Error Handling	Erl
	Error
	Resume, Resume Next
File Input/Output	All traditional Basic file I/O
Financial	All financial functions
Object Manipulation	TypeOf
Objects	Clipboard
Objects	Collection
Operators	Like
Options	Deftype
	Option Base
	Option Compare
	Option Private Module
Select Case	Expressions containing the `Is` keyword or any comparison operators
Select Case	Expressions containing a range of values using the `To` keyword
Strings	Fixed-length strings
	LSet, RSet
	Mid Statement
	StrConv
Using Objects	Collection access using !