<div>
This solution only worked a couple of times (out of many tries). PasteSpecial appears to work all the time.<br />
<br />
Any ideas why PasteExcelTable is unreliable?
</div>


This solution only worked a couple of times (out of many tries). PasteSpecial appears to work all the time.

Any ideas why PasteExcelTable is unreliable?

<div>
I'm not sure but it could have something to do with <br />
<br />
<a href="http://social.msdn.microsoft.com/Forums/en-US/vsto/thread/6452bd86-acdb-45f4-ae65-3329ea5d38d7" rel="ugc nofollow">http://social.msdn.microsoft.com/Forums/en-US/vsto/thread/6452bd86-acdb-45f4-ae65-3329ea5d38d7</a>
</div>


I'm not sure but it could have something to do with

http://social.msdn.microsoft.com/Forums/en-US/vsto/thread/6452bd86-acdb-45f4-ae65-3329ea5d38d7 [http://social.msdn.microsoft.com/Forums/en-US/vsto/thread/6452bd86-acdb-45f4-ae65-3329ea5d38d7]

<div>
The solution did not work consistently
</div>


<div>
<div class="content wysiwyg-content">
I am trying to automate (vie VBA) copying some Excel tables into a Word document at specific bookmarked locations. The following is a code snippet:<br />
<br />
&nbsp; &nbsp; 'this should copy the Excel table to the clipboard<br />
&nbsp; &nbsp; &nbsp;Range(strRangeName).Copy &nbsp; &nbsp; <br />
<br />
&nbsp; &nbsp; &nbsp;'this should paste the &nbsp;clipboard into the word document<br />
&nbsp; &nbsp; &nbsp;wrdrngBookMark.PasteAndFor<wbr />mat Type:=wdFormatOriginalForm<wbr />atting &nbsp;<br />
<br />
I am successfully copying charts across with the folowing:<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ActiveChart.ChartArea.Copy<wbr /><br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; wrdrngBookMark.PasteAndFor<wbr />mat Type:=wdChartPicture<br />
<br />
Please what am I doing wrong with the tables??<br />

</div>
</div>


I am trying to automate (vie VBA) copying some Excel tables into a Word document at specific bookmarked locations. The following is a code snippet:

    'this should copy the Excel table to the clipboard
     Range(strRangeName).Copy     

     'this should paste the  clipboard into the word document
     wrdrngBookMark.PasteAndFormat Type:=wdFormatOriginalFormatting  

I am successfully copying charts across with the folowing:
            ActiveChart.ChartArea.Copy
            wrdrngBookMark.PasteAndFormat Type:=wdChartPicture

Please what am I doing wrong with the tables??


Paste Excel Table to Word bookmark

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Word is a commercial document editing program that is part of the Microsoft Office suite. It features numerous text-editing tools for creating richly formatted documents, along with tools for the use of macros in Word documents. Word's native file formats are denoted either by a .doc or .docx file extension. Plugins permitting the Windows versions of Word to read and write formats it does not natively support, such as the OpenDocument format (ODF) are available. Word can import and display images in common bitmap formats such as JPG and GIF. It can also be used to create and display simple line-art.