Appendix J VBA Features not in VBScript

The following appendix lists VBA features that are not available in VBScript.

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