Thursday, April 17, 2014

Master list of VBScript Built-in functions

Abs Function: Returns the absolute value of a number.
Array Function: Returns a Variant containing an array.
Asc Function: Returns the ANSI character code corresponding to the first letter in a string.
Atn Function: Returns the arctangent of a number.
CBool Function: Returns an expression that has been converted to a Variant of subtype Boolean.
CByte Function: Returns an expression that has been converted to a Variant of subtype Byte.
CCur Function: Returns an expression that has been converted to a Variant of subtype Currency.
CDate Function: Returns an expression that has been converted to a Variant of subtype Date.
CDbl Function: Returns an expression that has been converted to a Variant of subtype Double.
Chr Function: Returns the character associated with the specified ANSI character code.
CInt Function: Returns an expression that has been converted to a Variant of subtype Integer.
CLng Function: Returns an expression that has been converted to a Variant of subtype Long.
Cos Function: Returns the cosine of an angle.
CreateObject Function: Creates and returns a reference to an Automation object.
CSng Function: Returns an expression that has been converted to a Variant of subtype Single.
CStr Function: Returns an expression that has been converted to a Variant of subtype String.
Date Function: Returns the current system date.
DateAdd Function: Returns a date to which a specified time interval has been added.
DateDiff Function: Returns the number of intervals between two dates.
DatePart Function: Returns the specified part of a given date.
DateSerial Function: Returns a Variant of subtype Date for a specified year, month, and day.
DateValue Function: Returns a Variant of subtype Date.
Day Function: Returns a whole number between 1 and 31, inclusive, representing the day of the month.
Eval Function: Evaluates an expression and returns the result.
Exp Function: Returns e (the base of natural logarithms) raised to a power.
Filter Function: Returns a zero-based array containing subset of a string array based on a specified filter criteria.
Fix Function: Returns the integer portion of a number.
FormatCurrency Function: Returns an expression formatted as a currency value using the currency symbol defined in the system control panel.
FormatDateTime Function: Returns an expression formatted as a date or time.
FormatNumber Function: Returns an expression formatted as a number.
FormatPercent Function: Returns an expression formatted as a percentage (multiplied by 100) with a trailing % character.
GetLocale Function: Returns the current locale ID value.
GetObject Function: Returns a reference to an Automation object from a file.
GetRef Function: Returns a reference to a procedure that can be bound to an event.
Hex Function: Returns a string representing the hexadecimal value of a number.
Hour Function: Returns a whole number between 0 and 23, inclusive, representing the hour of the day.
InputBox Function: Displays a prompt in a dialog box, waits for the user to input text or click a button, and returns the contents of the text box.
InStr Function: Returns the position of the first occurrence of one string within another.
InStrRev Function: Returns the position of an occurrence of one string within another, from the end of string.
Int Function: Returns the integer portion of a number.
IsArray Function: Returns a Boolean value indicating whether a variable is an array.
IsDate Function: Returns a Boolean value indicating whether an expression can be converted to a date.
IsEmpty Function: Returns a Boolean value indicating whether a variable has been initialized.
IsNull Function: Returns a Boolean value that indicates whether an expression contains no valid data (Null).
IsNumeric Function: Returns a Boolean value indicating whether an expression can be evaluated as a number.
IsObject Function: Returns a Boolean value indicating whether an expression references a valid Automation object.
Join Function: Returns a string created by joining a number of substrings contained in an array.
LBound Function: Returns the smallest available subscript for the indicated dimension of an array.
LCase Function: Returns a string that has been converted to lowercase.
Left Function: Returns a specified number of characters from the left side of a string.
Len Function: Returns the number of characters in a string or the number of bytes required to store a variable.
LoadPicture Function: Returns a picture object. Available only on 32-bit platforms.
Log Function: Returns the natural logarithm of a number.
LTrim Function: Returns a copy of a string without leading spaces.
Mid Function: Returns a specified number of characters from a string.
Minute Function: Returns a whole number between 0 and 59, inclusive, representing the minute of the hour.
Month Function: Returns a whole number between 1 and 12, inclusive, representing the month of the year.
MonthName Function: Returns a string indicating the specified month.
MsgBox Function: Displays a message in a dialog box, waits for the user to click a button, and returns a value indicating which button the user clicked.
Now Function: Returns the current date and time according to the setting of your computer's system date and time.
Oct Function: Returns a string representing the octal value of a number.
Replace Function: Returns a string in which a specified substring has been replaced with another substring a specified number of times.
RGB Function: Returns a whole number representing an RGB color value.
Right Function: Returns a specified number of characters from the right side of a string.
Rnd Function: Returns a random number.
Round Function: Returns a number rounded to a specified number of decimal places.
RTrim Function: Returns a copy of a string without trailing spaces.
ScriptEngine Function: Returns a string representing the scripting language in use.
ScriptEngineBuildVersion Function: Returns the build version number of the scripting engine in use.
ScriptEngineMajorVersion Function: Returns the major version number of the scripting engine in use.
ScriptEngineMinorVersion Function: Returns the minor version number of the scripting engine in use.
Second Function: Returns a whole number between 0 and 59, inclusive, representing the second of the minute.
SetLocale Function: Sets the global locale and returns the previous locale.
Sgn Function: Returns an integer indicating the sign of a number.
Sin Function: Returns the sine of an angle.
Space Function: Returns a string consisting of the specified number of spaces.
Split Function: Returns a zero-based, one-dimensional array containing a specified number of substrings.
Sqr Function: Returns the square root of a number.
StrComp Function: Returns a value indicating the result of a string comparison.
String Function: Returns a repeating character string of the length specified.
StrReverse Function: Returns a string in which the character order of a specified string is reversed.
Tan Function: Returns the tangent of an angle.
Time Function: Returns a Variant of subtype Date indicating the current system time.
Timer Function: Returns the number of seconds that have elapsed since 12:00 AM (midnight).
TimeSerial Function: Returns a Variant of subtype Date containing the time for a specific hour, minute, and second.
TimeValue Function: Returns a Variant of subtype Date containing the time.
Trim Function: Returns a copy of a string without leading or trailing spaces.
TypeName Function: Returns a string that provides Variant subtype information about a variable.
UBound Function: Returns the largest available subscript for the indicated dimension of an array.
UCase Function: Returns a string that has been converted to uppercase.
VarType Function: Returns a value indicating the subtype of a variable.
Weekday Function: Returns a whole number representing the day of the week.
WeekdayName Function: Returns a string indicating the specified day of the week.
Year Function: Returns a whole number representing the year.