As the title says I am trying to take multiple tables from a Word document and import them into an Excel worksheet. Currently I have found two versions that when combined, could yield what I am looking for. The first one imports the table's data from Word, but does not maintain formatting of the table (font, colors, rows/columns etc.):The next code maintains formatting, but only imports/pastes one table:Please Login or Register to view this content.
For the second one, I do not like the fact that it is calling a specific Workbook to paste into. If I could somehow maintain the ability to import/past multiple tables while keeping formatting that would be perfect. An extra bonus would be to import each table within the Word document into individual Worksheets in Excel. I am also using Office 2010. Thanks! References: http://www.mrexcel.com/forum/excel-q...worksheet.html vba - How to preserve source formatting while copying data from word table to excel sheet using VB macro? - Stack OverflowPlease Login or Register to view this content.
Bookmarks