AnsweredAssumed Answered

DataLink Functions Exposed to VBA Code - Used in Macro

Question asked by stevensnashall on Oct 2, 2015
Latest reply on Oct 2, 2015 by Kenji Hashimoto

Can anyone provide a full list of all the functions within DataLink, that are exposed to VBA (and therefore become available to be used in a macro) other than just the “ ResizeRange” used in the following script?

 

Dim addIn As COMAddIn

Dim automationObject As Object

 

Set ws = Worksheets("Sheet1")

Set MyRange = ws.Range("a1")

Set addIn = Application.COMAddIns("PI DataLink")

Set automationObject = addIn.Object

 

automationObject.ResizeRange

 

Looking to take advantage of VBA code to speed up/optimise DataLink reports.

Outcomes