2 Replies Latest reply: Mar 6, 2014 4:08 PM by neetha P RSS

    Export to PPT Subscript out of range Error

    neetha P

      Hi All,


      I created Macro to export Qlikview objects to Power Point Presentation, it can export the chart to PPT when I test in module with two objects,but when i try to export with 3rd object its giving error -- Subscript out of range: '[number: 2]'


      Sub Export_ppt


      Dim myArray(1)


      myArray(0) = "LB04"

      myArray(1) = "LB06"

      myArray(2) = "CH02"


      Set objPPT = CreateObject("PowerPoint.Application")

      objPPT.Visible = True

      Set objPresentation = objPPT.Presentations.Add

      For count = 0 to ubound(MyArray)

      Set PPSlide = objPresentation.Slides.Add(1,11)






      Set PPSlide = Nothing

      Set PPPres = Nothing

      Set PPApp = Nothing


      End Sub



      Please any help will be appreciated