CData Excel Add-In for Reckon 2019 - Online Help
Questions / Feedback?

Connecting from VBA

CData Excel Add-In for Reckon 2019 - Build 19.0.7354

To execute SQL to Reckon, initialize an ExcelComModule instance. This class can be used with any CData provider. You can call the following methods to initialize the module for working with Reckon:

  • SetProviderName
  • SetConnectionString

You can use the following code to start Querying Data.

Dim module As New ExcelComModule
module.SetProviderName ("Reckon")
module.SetConnectionString("User=test;Password=test;URL=http://localhost:8166;")

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0