Introduction to Extended Functions

AutoMate provides a library of additional functions that extend the functionality of the AutoMate Scripting Engine beyond the capabilities that the basic VBA-compatible engine provides. These functions, collectively referred to as AutoMate Extended Functions, provide operations in several areas to provide more functionality and make formulating AutoMate scripts even easier. These functions provide a more straightforward approach to file related operations, date/time manipulation, and viewing or modifying attributes of a running task. The extended functions can be used from within any AutoMate action just like the normal VBA-compatible functions.

AutoMate extended functions can be extremely useful because they provide added functionality to a given task. The extended functions are capable of returning multiple attributes in regards to the task currently being executed, such as returning the path and filename of the presently running task, returning the amount of time the task or particular step within the task took to execute in minutes, seconds or milliseconds or returning the last error generated by a task step. They can supply system information, such as returning the computer name that AutoMate is running on, returning the IP address of the specified host name or local machine or returning the amount of space remaining on a specific drive. The extended functions can perform extensive date/time and file related procedures as well, such as returning the first or last day of the specified month, quarter or year, returning the number of files found in the specified folder or extracting the file name or the path within a particular string.

The general format of a function is its name followed by any arguments contained in between parenthesis. For example: FunctionName (arguments)

Similar to the regular VBA-compatible functions, some Automate extended functions may or may not require other parameters in order to properly complete a procedure or routine. A function without arguments must include an empty set of parentheses ().

For more details in regards to the use of functions, see Using Functions.

A full library of pre-defined AutoMate extended functions can be found in the lower left pane of the Expression Builder under the Extended Functions folder. Help regarding each extended function can be accessed by first selecting the Extended Functions folder, then selecting the desired extended function from the lower right pane and pressing the F1 key or by right-clicking the extended function and selecting Help from the popup menu that appears.

See Also:

Introduction to AutoMate Scripting

Introduction to Functions

The BASIC Language Grouped by Type

More on Operators

Order of Precedence