VBScript in a Nutshell

Name

TypeName Function

Syntax

TypeName(varname)

varname

Use: Required

Data Subtype: Any

The name of a variable.

Return Value

A Variant of subtype String.

Description

Returns a string containing the name of the data subtype of a variable.

Rules at a Glance

• TypeName returns the variant’s data subtype. If the variant has not been assigned a value, TypeName returns Empty. Therefore, TypeName never actually returns the string “Variant.”

• The following table describes the possible return values and their meaning:

Return Value	Underlying Datatype
Boolean	Boolean
Byte	Byte
classname	An object variable of type classname
Currency	Currency
Date	Date
Decimal	Decimal
Double	Double-precision floating-point number
Empty	Uninitialized variant
Error	An error
Integer	Integer
Long	Long integer
Nothing	Unassigned object variable
Null	No valid data
Object	Variable explicitly declared as type Object
Single	Single-precision floating-point number
String	String
Unknown	An object whose type is unknown
Variant( )	An array

VBA/VBScript Differences

• In VBA, the datatype of a strongly typed variable can be ascertained earlier than can the data subtype of a VBScript variable. For instance, in VBA, the code fragment:

  Dim lNumber As Long
  MsgBox TypeName(lNumber)

  indicates that lNumber is a long. The equivalent VBScript code fragment:

  Dim lNumber
  MsgBox TypeName(lNumber)

  indicates that lNumber is Empty, since it hasn’t yet been assigned a value and therefore VBScript cannot determine its ...