Alphabetical A - M

ABSReturns the absolute value of a number (Variant).
ANDThe logical "AND" operator (Boolean).
APPACTIVATEActivates an application or window currently running on Windows.
ARRAYReturns the array containing the given values (Variant).
ASCReturns the ANSI number for the first character in a text string (Integer).
ATNReturns the arctangent of a number in radians (Double).
BEEPProduces a single beep noice.
CALLTransfers control to a procedure.
CALLBYNAMEReturns, sets or executes a method or property of an object (Variant).
CBOOLReturns the expression converted to a boolean data type (Boolean).
CBYTEReturns the expression converted to a byte data type (Byte).
CCURReturns the expression converted to a currency data type (Currency).
CDATEReturns the expression converted to a date data type (Date).
CDBLReturns the expression converted to a double data type (Double).
CDECReturns the expression converted to a decimal variant-subtype (Variant).
CHDIRDefines the current default directory.
CHDRIVEDefines the current default drive.
CHOOSEReturns the value from a list of values based on an index number (Variant).
CHRReturns the character with the corresponding ANSI number (String).
CINTReturns the expression converted to an integer data type (Integer).
CLNGReturns the expression converted to a long data type (Long).
CLNGLNGReturns the expression converted to a longlong (64 bit platform) data type.
CLNGPTRReturns the expression converted to a longptr data type.
CLOSECloses a text file.
COMMANDReturns the argument portion of the command line used to launch the application (Variant).
COSReturns the cosine of an angle in radians (Double).
CREATEOBJECTReturns a reference after creating a new ActiveX or OLE object (Variant).
CSNGReturns the expression converted to a single data type (Single).
CSTRReturns the expression converted to a string data type (String).
CURDIRReturns the current path of a given drive (String).
CVARReturns the expression converted to a variant data type (Variant).
CVDATEReturns the expression converted to a date data type (Variant).
CVERRReturns a specific type of error (Variant).
DATE - FunctionReturns the current system date (Date).
DATE - StatementDefines the current system date.
DATEADDReturns the date to which a specified time interval has been added (Date).
DATEDIFFReturns the number of time intervals between two specified dates (Long).
DATEPARTReturns the specified part of a given date (Integer).
DATESERIALReturns the date given a year, month and day (Date).
DATEVALUEReturns the date given a string representation of a date (Date).
DAYReturns the day from a given date (Integer).
DDBReturns the depreciation of an asset over a period of time (Double).
DELETESETTINGRemoves (or deletes) a key or section from the registry.
DIRReturns the name of a file or directory matching a pattern or attribute (String).
DOEVENTSPauses execution to let the system process other events.
ENVIRONReturns information about the current operating system environment (String).
EOFReturns the boolean value indicating if the end of a file has been reached (Boolean).
EQVThe bitwise comparison operator.
ERASEReinitialises the elements of an array.
ERRORReturns the error message corresponding to a given error number (String).
EXPReturns the base of natural logarithm raised to a power (Double).
FILEATTRReturns the file mode of the specified open file (Long).
FILECOPYCopies a file from one directory to another.
FILEDATETIMEReturns the date and time when a file was created or last modified (Date).
FILELENReturns the length of a file in bytes (Long).
FILTERReturns an array containing a subset of a string array based on a filter criteria (Variant).
FIXReturns the integer portion of a number (Double).
FORMATReturns the text string of a number or date in a particular format (String).
FORMATCURRENCYReturns the expression formatted as a currency value (String).
FORMATDATETIMEReturns the expression formatted as a date or time (String).
FORMATNUMBERReturns the expression formatted as a number (String).
FORMATPERCENTReturns the expression formatted as a percentage (String).
FREEFILEReturns the next valid free file number (Integer).
FVReturns the future value of a series of equal cash flows at regular intervals (Double).
GETReads data from an open file into a variable.
GETALLSETTINGSReturns the list of key settings and their values from the registry (Variant).
GETATTRReturns the attributes of a given file or directory (Integer).
GETOBJECTReturns the reference to an object provided by an ActiveX component.
GETSETTINGReads from the registry and returns the value or key from the registry (String).
GOTOTransfers control to the subroutine indicated by the line label.
HEXReturns the number converted to hexadecimal (String).
HOURReturns the hour from a given time (Integer).
IIFReturns one of two parts, depending on the evaluation of an expression.
IMESTATUSReturns the current Input Method Editor mode of Microsoft Windows (Integer).
IMPThe logical implication from two values (Variant).
IMPLEMENTSSpecifies an interface or class that can be implemented in a class module.
INPUT - FunctionReturns the open stream of an Inout or Binary file (String).
INPUT - StatementReads data from an open sequential field and assigns the data to a variable (Long).
INPUTBOXDisplays a dialog box allowing the user to enter some information (String).
INSTRReturns the position of a substring within a larger string (Long).
INSTRREVReturns the position of a substring within a larger string, from the end (Long).
INTReturns the number rounded down to the nearest integer (Double).
IPMTReturns the interest paid in a given period in a series of equal cash flows at regular intervals (Double).
IRRReturns the internal rate of return for a series of cash flows (Double).
ISCompares two object reference variables.
ISARRAYReturns the value indicating if an expression is an array (Boolean).
ISDATEReturns the value indicating if an expression is a date (Boolean).
ISEMPTYReturns the value indicating if a variable has been initialised (Boolean).
ISERRORReturns the value indicating if an expression is an error (Boolean).
ISMISSINGReturns the value indicating if an optional argument has been passed to a procedure (Boolean).
ISNULLReturns the value indicating if an expression contains no data (Boolean).
ISNUMERICReturns the value indicating if an expression contains a number (Boolean).
ISOBJECTReturns the value indicating if an identifier represents an object (Boolean).
JOINReturns the text string containing the elements in an array (String).
KILLDeletes an existing file.
LBOUNDReturns the smallest subscript in a given dimension of an array (Long).
LCASEReturns the text string with all characters converted to lowercase (String).
LEFTReturns a number of characters from the left of a string (String).
LENReturns the number of characters in a string (Long).
LETComputes a value and assigns it to a new variable.
LIKEThe pattern matching operator.
LINEINPUTReads a single line from an Open sequential file and assigns it to a string.
LOADLoads an object but doesn't display it.
LOADPICTURELoads a picture from a file into a Picture or Image control (IPictureDisp).
LOCReturns the current read/write position within an open file (Long).
LOCKLocks access to parts of a file for other processes.
LOFReturns the size of an open file, in bytes (Long).
LOGReturns the natural logarithm of a number (Double).
LSETLeft justifies a string within a destination and fills the remainder with spaces.
LTRIMReturns the text string without leading spaces (String).
MACIDConverts a four character constant to a value that can be used by Dir, Kill, Shell and AppActivate.
MID - FunctionReturns the text string which is a substring of a larger string (String).
MID - StatementReplaces a specified number of characters with characters from another string.
MINUTEReturns the minute from a given time (Integer).
MIRRReturns the internal rate of return for a series of cash flows (Double).
MKDIRCreates a new directory.
MODReturns the remainder after division (Integer).
MONTHReturns the month from a given date (Integer).
MONTHNAMEReturns the month as a string (String).
MSGBOXDisplays a dialog box displaying a message to the user (Integer).

© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited