![]() IsObject Returns a value indicating whether an expression references a valid Automation object. Int Returns the integer portion of a number. InStrRev Returns the position of the first occurrence of one string within another, searching from the end of string. InStr Returns the position of the first occurrence of one string within another. Increment Atomically increments the value of a variable and returns the new value. Hour Returns a whole number between 0 and 23, inclusive, representing the hour of the day. Hex Returns a string representing the hexadecimal value of a number. Fix Returns the integer portion of a number. Exp Returns e (the base of natural logarithms) raised to a power. ![]() Derived Math Functions The following non-intrinsic math functions can be derived from the intrinsic math functions: Exists Returns the existence status of variables and their array subnodes. Day Returns the day of the month as an integer between 1 and 31, inclusive. DateTimeConvert Converts date/time between internal and external formats. DateSerial Returns the date for a specified year, month, and day. DatePart Returns the specified part of a given date. DateDiff Returns the number of intervals between two dates. DateConvert Converts dates between internal and external formats. DateAdd Returns a date to which a specified time interval has been added. Chr Returns the character corresponding to the specified ANSI character code. Case Compares a target to cases and returns the value associated with the first matching case. Atn Returns the arctangent of a number. Asc Returns the ANSI character code corresponding to the first character in a string. With Executes a series of statements on a single object.Ībs Returns the absolute value of a number. While.Wend Executes a series of statements as long as a given condition is true. TStart Marks the beginning of a transaction. Try Identifies a block of code to monitor for errors during execution. TRollback Rolls back (reverts) changes made during the current transaction. Throw Throws an exception from a Try block to a Catch exception handler. TCommit Marks the successful completion of a transaction. Sub Declares the name, arguments, and code that form the body of a Sub procedure. Sleep Causes program execution to delay for the specified number of seconds. Set Assigns an object reference to a variable or property. Select Case Executes one of several groups of statements, depending on the value of an expression. Return Exits from the current function and returns a value from that function. Rem Used to include explanatory remarks in a program. Randomize Initializes the random-number generator. Print, Println Writes a string to the current device. Option Explicit Used at script level to force explicit declaration of all variables in that script. OpenId Opens a new instance of an object for a given Identifier. On Error Goto Enables an error-handling routine and specifies the location of the routine within a procedure. New Creates a new instance of an object. Merge Merges array elements from source to target. Let Assigns an object reference to a variable or property. Input Accepts input and stores it in a variable. If.Then.Else Conditionally executes a group of statements, depending on the value of an expression. Goto Transfers program execution to the specified location. Function Declares the name, arguments, and code that form the body of a Function procedure. For.Next Repeats a group of statements a specified number of times. For Each.Next Repeats a group of statements for each element in an array or collection. ![]() Exit Exits a block of Do.Loop, For.Next, Function, or Sub code. EraseValue Removes the root node of a variable. EraseArray Removes the array elements of a variable and deallocates dynamic-array storage space. Erase Removes the named variable and deallocates dynamic-array storage space. Do.Loop Repeats a block of statements while a condition is True or until a condition becomes True. Debug Interrupts program execution and enters programmer mode. Copy Copies array elements from source to target. Continue Jumps to FOR or DO WHILE statements and reexecutes test and loop. Const Declares constants for use in place of literal values. Catch Identifies a block of code to execute when an exception occurs. Call Transfers control to a Sub procedure or Function procedure.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |