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

Connecting from VBA

CData Excel Add-In for Office 365 2019 - Build 19.0.7354

To execute SQL to Office 365, 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 Office 365:

  • SetProviderName
  • SetConnectionString

You can use the following code to start Querying Data.

Dim module As New ExcelComModule
module.SetProviderName ("Office365")
module.SetConnectionString("OAuthClientId=MyApplicationId;OAuthClientSecret=MySecretKey;CallbackURL=http://localhost:33333;")

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