If I generate a table in Excel using automation, and then copy and paste it into a Word document also using automation, how can I control where it is placed in the Word document, or how can I get a handle on the pasted table so that it can be positioned on the page. I am selecting a bookmark in the Word document prior to the paste, but the table ends up below the bookmark and left of the document margin. I would like the table to be either at the left margin or centered on the page.
Thanks
with oWord
do recap_chart with lcPermID, lnYear
.ActiveDocument.Bookmarks("ExcelTable").select
.selection.Paste
endwith