copy word table to excel with formatting

Once they've tweaked the XLS and DOT, they will run the same Macro (the hope is they wouldn't have to dig-into code) on a regular basis. With this in mind, I want the starting DOTX to be able to visually indicate that a table will be dumped once running the macro, and I'm thinking that having an existing table there is the easiest way to accomplish this (plus, I can add some documentation into the table too). People receiving the macro, word template, and add-in will modify the layout of the XLS and DOTX a bit to suit their needs.

It explains what I expect to give to others, what I expect them to change, and why I want the layout it to be as obvious and universally understood as possible. I'm including a workflow chart to explain the use for this macro (I made it in PPT). I expect that running the code twice (and incrementing Tables(2)) will replace multiple tables in series (such that Word maintains order of Tables list as the same as the order in the document). 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.Thanks for the code on deleting and replacing the table in the same range. 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 with formatting