VBA Function Library

The user can interact with 1010data using Visual Basic for Applications macros through a set of functions supplied by the 1010data Excel Add-in.

The 1010data Excel Add-in provides a number of VBA functions that can be called to execute queries programmatically from VBA macros. These allow the user to run a complex set of queries with dynamic input or to create jobs that can be scheduled to run at designated times. Using these functions, you can log in or out of 1010data, run queries, clear the cache, or upload data.

To call these functions programmatically, your VBA project must have a reference to the 1010data Excel Add-in. To add the reference, click Tools > References from the VBA menu bar, select A1010data from the list of available references, and click OK.