The following table lists Visual Basic for Applications Features not in VBScript.
Features
Category | Omitted Feature/Keyword |
---|---|
Array Handling |
Option Base Declaring arrays with lower bound <> 0 |
Collection |
Add, Count, Item, Remove Access to collections using ! 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 (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 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 ! |