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

    DataLink Functions Exposed to VBA Code - Used in Macro

    stevensnashall

      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.