 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Programming / January 2007Inserting a table with Format from Excel into Word
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. Insert as OLE object? Krgrds, Perry >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. >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/ > >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 [quoted text clipped - 4 lines] > 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. 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("A5:D11").Copy wdApp.Selection.Paste
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.