Inserting a table with Format from Excel into Word

[ajaypondicherry]

I would like to export a table from excel into word while preserving
the excel formatting. I would like the word doc to appear as if I had
selected the table in excel; copied it; and pasted it into word. I
understand the .Text and insert.after.text functions, but I am not
sure how to preserve the table format.

 

[Perry]

Insert as OLE object?

Krgrds,
Perry

 

[Charlie Hoffpauir]

I would like to export a table from excel into word while preserving
the excel formatting. I would like the word doc to appear as if I had
selected the table in excel; copied it; and pasted it into word. I
understand the .Text and insert.after.text functions, but I am not
sure how to preserve the table format.

Why not just copy and paste?
Charlie Hoffpauir
http://freepages.genealogy.rootsweb.com/~charlieh/

 

[ajaypondicherry]

Why not just copy and paste?
Charlie Hoffpauirhttp://freepages.genealogy.rootsweb.com/~charlieh/

What is the best way to paste something into word? I was thinking of
setting the table as a variable and inserting it into the word
document, but I am not sure what kind of variable I should use. Is it
the range variable?

Thanks for the help so far.

 

[ajaypondicherry]

Ok so I discovered how to paste the table into word, but it is
autmoatically pasting it at the very top of the document. I would like
it to be pasted at the end or at least after the text which I am
inserting.

'This is the text which will be entered in the MS Word document
With mywdRange
..Text = "Text goes here"

'This is an excel table which will be pasted into the word doc with
formatting
Sheet2.Range("A511").Copy
wdApp.Selection.Paste