AnsweredAssumed Answered

DataLink Function VBA Code

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