Microsoft KB Archive/190273

= INFO: Visual Basic for Applications Features Not in VBScript =

Article ID: 190273

Article Last Modified on 8/27/2007

-

APPLIES TO


 * Microsoft Visual Basic, Scripting Edition 1.1
 * Microsoft Visual Basic, Scripting Edition 2.0
 * Microsoft Visual Basic, Scripting Edition 3.0

-



This article was previously published under Q190273



SUMMARY
Here is a list of features or keywords in Visual Basic for Applications that have been omitted from VBScript.



MORE INFORMATION
Following are Visual Basic for Applications features that are not 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 ! character (e.g., MyCollection!Test)

Conditional Compilation #Const #If...Then...#Else

Control Flow           DoEvents GoSub...Return, GoTo On Error GoTo On...GoSub, On...GoTo Line numbers, Line labels With...End With

Conversion             CVar, CVDate Str, Val

Data Types             All intrinsic data types except Variant Type...End Type

Date/Time              Date statement, Time statement Timer

DDE                    LinkExecute, LinkPoke, LinkRequest, LinkSend

Debugging              Debug.Print End, Stop

Declaration            Declare (for declaring DLLs) New Optional ParamArray Property Get, Property Let, Property Set Static

Error Handling         Erl Error On Error...Resume 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 !

