2 Replies Latest reply on Oct 2, 2015 8:06 AM by Kenji Hashimoto

    DataLink Functions Exposed to VBA Code - Used in Macro


      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




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