title: Copy and paste an excel chart with a VBA macro in word
body: <p>I'm aware that my question may sound/be trivial, but I couldn't find the solution anywhere...and I'm exhausted.</p>
  
  <p>I'm writing a macro to automatize a report generation in Word. At some stage, I need to insert some chart, which is located as a chartsheet from excel...but no way. Here's my code</p>
  
  <pre><code>Sub copy_pic_excel()
  Dim xlsobj_2 As Object
  Dim xlsfile_chart As Object
  Dim chart As Object
  
  Set xlsobj_2 = CreateObject("Excel.Application")
  xlsobj_2.Application.Visible = False
  Set xlsfile_chart = xlsobj_2.Application.Workbooks.Open("path_to_file.xlsx")
  
  Set chart = xlsfile_chart.Charts("sigma_X_chart")
  chart.Select
  chart.Copy
  With Selection
  .PasteSpecial Link:=False, DataType:=wdPasteEnhancedMetafile, _
  Placement:=wdInLine, DisplayAsIcon:=False
  End With
  End Sub
  </code></pre>
  
  <p>But it keeps showing the error message: "Run-time error '5342': The specified data type is unavailable."</p>
  
  <p>I have no clue why it isn't pasting the chart. I thought to use the clipboard via 'MSForms.DataObject', but i seems that it only works with text (or strings). As far as I understand I have everything that is required, but obviously there's something missing. </p>
  
  <p>Any idea?</p>