Vba Word add table after copying table from Excel
<p>The macro is written in Excel. I have copied the table to word first page from excel and then I would like to insert table into page 2 in word.But from below the set "MyRange" returning empty and table with 1 row is not creating.  </p>

<pre><code>   Set objWord = CreateObject("Word.Application")
   Set objDoc = objWord.Documents.Open(str_path_folder &amp; "\" &amp; AdID &amp; ".dotm")
    objWord.Visible = True
    objDoc.Activate
    AppActivate AdID &amp; ".dotm"
    Sheets("Meta").Select
    Range("B1:E" &amp; LastRow).Select
    Selection.Copy
    objWord.Selection.PasteExcelTable False, False, False
    objDoc.Tables(1).AutoFitBehavior wdAutoFitContent
   objWord.Selection.InsertBreak.Type = wdPageBreak
   Set MyRange = ActiveDocument.Content
   MyRange.collapse Direction:=wdCollapseEnd
   ActiveDocument.Tables.Add Range:=MyRange, NumRows:=1, _
   NumColumns:=1, DefaultTableBehavior:=wdWord9TableBehavior,       AutoFitBehavior:=wdAutoFitFixed
</code></pre>

<p>Also if i use below it is replacing the already copied table in page 1:</p>

<pre><code>objDoc.Tables.Add Range:=objDoc.Range, NumRows:=3, NumColumns:=2, DefaultTableBehavior:=wdWord9TableBehavior, AutoFitBehavior:=wdAutoFitFixed
</code></pre>