title: rearrange charts in powerpoint using VBA
body: <p>I created some graphs in Excel using VBA. Now I would like to send it to my PP template and arrange 4 charts in the same slide, then skip to the next slide and add another 4 charts. All charts need to be resized and rearranged.
  I managed to export the first 4 charts, but when I want to arrange them and fit the size then I run in to problems. I have limited VBA experience and no experience using VBA together with MS PP.</p>
  <p>My code so far:</p>
  <pre><code>    Dim PPT As Object
      Dim chr
      Set PPT = CreateObject(&quot;Powerpoint.Application&quot;)
      PPT.Visible = True
      PPT.Presentations.Open Filename:=&quot;C:\VBA Projects\XXX\XXX.ppt&quot;
  '    Set PPT = Nothing
      PPT.ActiveWindow.View.GotoSlide 4
      For Each chr In Sheets(&quot;Output&quot;).ChartObjects
          chr.Select
          ActiveChart.CopyPicture Appearance:=xlScreen, Size:=xlScreen, Format:=xlPicture
          PPT.ActiveWindow.View.Paste
      Next chr
  
  End Sub
  </code></pre>
  <p>How can I choose between the charts and manipulate them individually?</p>
  <p>Thank you</p>