10 Replies Latest reply on Jan 12, 2017 9:38 PM by HardikS

    i would like to use excel draw polygon method Shapes.AddPolyline in PI Process book . But in process book vba it is not supported. Is there any option like i can create an object for excel and from that can use excel properties in processbook vba.?

    HardikS

      Dim triArray(1 To 4, 1 To 2) As Single

      triArray(1, 1) = 2

      triArray(1, 2) = 5

      triArray(2, 1) = 3

      triArray(2, 2) = 3.2

      triArray(3, 1) = 4

      triArray(3, 2) = 5

      triArray(4, 1) = 2

      triArray(4, 2) = 5

      Set myDocument = Worksheets(1)

      myDocument.Shapes.AddPolyline triArray