Excel Add-In for Microsoft Dynamics 365

Build 22.0.8462

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.

Updating Data

Execute create, read, update, and delete (CRUD) operations by calling the corresponding method. See Modifying Data for examples.

Calling Stored Procedures

Call stored procedures through the CallSP method. See Calling Stored Procedures for more information.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462