title: VBA paste msoChart into Powerpoint 2010
body: <p>I am trying to paste an msoChart object with embedded data from the clipboard into PowerPoint 2010 using VBA. (chart created in Excel 2010).</p>
  <p>The only examples that I can find involve either linking the Chart to an Excel file or creating a msoEmbeddedOLEObject.</p>
  <p>If I manually paste in PowerPoint 2010 I get a paste option to &quot;Embed Workbook&quot;. However it is not available within manual &quot;Paste Special&quot;.</p>
  <p>So it would seem that something in addition to pasting the chart is needed. But I am unsure what that is or how to go about it.</p>
  <p>What I have tried is</p>
  <pre><code>Sub PasteExample()
  Dim Sld As Slide
  Dim Shp As ShapeRange
  
      Set Sld = ActiveWindow.View.Slide
      
      '# This pastes clipboard content as a linked chart
      Set Shp = Sld.Shapes.Paste
  End Sub
  
  Sub PasteExample2()
  Dim Sld As Slide
  Dim Shp As ShapeRange
  
      Set Sld = ActiveWindow.View.Slide
  
      '# This option does not work, object is still linked
      'Set Shp = Sld.Shapes.PasteSpecial(DataType:=ppPasteDefault, Link:=msoFalse)
  
      '# This option does not work, object is still linked
      'Set Shp = Sld.Shapes.PasteSpecial(DataType:=ppPasteShape, Link:=msoFalse)
      
      '# I'm not after OLEObjects
      'Set Shp = Sld.Shapes.PasteSpecial(DataType:=ppPasteOLEObject, Link:=msoFalse)
  End Sub
  </code></pre>
  <p>Many thanks if you can shed some light.</p>