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
returnsEmpty
. 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 |
|
An object variable of type |
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
isEmpty
, since it hasn’t yet been assigned a value and therefore VBScript cannot determine its ...
Get VBScript in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.