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 ! |