Excel Add-In for xBase

Build 23.0.8770

Using the Excel Add-In (VBA)

The following sections walk through creating an example macro that shows how to execute SQL in VBA. See Invoking UI Elements to automate the functionality available on the CData ribbon.

Connecting from VBA

Define a connection and initialize an ExcelComModule. See Connecting from VBA for a guide.

Querying Data

Execute SELECT queries. See Querying Data for examples.

Executing Parmameterized Queries

Pass arrays as the inputs to parameterized queries. See Executing Parameterized Queries for example code.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8770