copy word table to excel keep formatting

Usually I format the table in Word making notes about the formatting steps then code in Excel VBA (if you have a better approach please share :)).

It always depends on your range (how many columns, rows, content etc.). So it is obvious the Word table needs some formatting. Though the result will look ugly, something like below:

WordDoc.Paragraphs(paragraphCount).Range.Paste ' -ĭim paragraphCount As Long Set sh_source = ThisWorkbook.Sheets( 'SourceToCopy')ĪppWord.Visible = True 'create new word doc ' Purpose: Copy an Excel range to a Word table without formatting Perform some basic formatting on the Word table:ġ-6 steps get the Excel range to a Word tableĬopying an Excel range to a Word table requires only a couple of code lines: '.Copy the range to the new Word document (it is going to be a Word table).Find the last paragraph in the Word document (it will be always the 1st in this example, since we are adding a new document).Select the Excel range (in the example it is a name: “rngCopyToWord”).Create a new instance of Microsoft Word and make it visible.It means that this example is Office suit version dependent and works with Office 2016, if you are using earlier version do not forget to change the Word object library reference. In the example I am using early biding (adding Word object library reference in advance VBE -> Tools -> References -> Microsoft Word xx.y Object Library). If you are copying a simple Excel range to a Word document, by default Word will paste it to a table. Maintain formatting only - imports all formatting that is applied to the textĭiscard fonts and formatting - ignores all fonts and formatting that are applied to the textĬhoose the drive and folder where the text file is stored.In this post we are going to copy an Excel worksheet to a Word table. Maintain fonts and formatting - imports all fonts and formatting that are applied to the text To import a table from Quattro Pro or ExcelĬhoose the drive and folder where the spreadsheet is stored.įrom the Import tables as list box, choose Tables. You can also import tables created in a word-processing application, such as WordPerfect or Microsoft Word.

With CorelDRAW, you can create tables by importing content from Quattro Pro (.qpw) and Microsoft Excel (.xls) spreadsheets.

To import a table from a word-processing document To import a table from Quattro Pro or Excel

Copy word table to excel keep formatting