Pasting an Excel chart into a Word document so it is editable but not linked
<p>I'm using VBA to create a series of charts in Excel and then copying them into a Word file.
Up till now I've been pasting the charts as pictures, so in Excel I used 
<code>ActiveChart.CopyPicture</code>
and then in Word, after selecting the target location:<code>Selection.Paste</code>.</p>

<p>Now I want to change it so the charts will be editable but not linked to the source Excel file.
I copy a chart from Excel using <code>ActiveChart.ChartArea.Copy</code>and look at the paste-special options in Word, the options "use destination theme/keep source formatting &amp; embed workbook" work fine for me: 
<a href="https://i.stack.imgur.com/z12Yx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/z12Yx.png" alt="enter image description here"></a>
the chart is editable (also the data is editable which I don't need but is OK) and there is no link to the original Excel file.</p>

<p>BUT - I can't find how to perform this through VBA code. Trying to record this in a macro only give me <code>Selection.Paste</code> - which pastes a linked chart.</p>

<p>I also tried a different approach - pasting a linked chart, and then killing the link. once again, deleting the links in the link editor doesn't get recorded in the macro at all.</p>

<p>Please help with coding any of these two options or suggesting a different approach.</p>