copy word table to excel keep formatting

Method 4: Use Right-click, Drag, and Drop Technique. Method 3: Use the Ctrl, Drag, and Drop Technique. Method 2: Use the Paste Special Dialog Box. QUESTION: Is this task even possible to achieve in VBA? I'd love to find a simple and elegant solution, but at this point I would settle for something that WORKS. This tutorial shows you 5 easy techniques for copying and pasting in Excel without changing the format. PROBLEM WITH METHOD 03: It works with only 1 cell, but as soon as I attempt to get more than one cell copied and pasted over, the result is the same data over and over again across multiple cells. Select the options you want, then click OK. Click Convert to Text in the Data group of the ribbon. Select the entire table (click in the table and press Alt+Num 5) Activate the Layout tab of the ribbon. 'In Excel, Save changes to cell and move 1 cell to the right Start by pasting normally, resulting in a table with formatted text. 'Select the appropriate cell in the active Excel worksheet (based on the For Loop) What version of Office are you using I just copied a tabel from Excel, and Pasted it into Word, and it was a perfect copy (with no spaces). 'for some reason Application.caption works for me. 'Note: I'm not sure why AppActivate ('excel') does not work, but 'Select the appropriate cell in the Word table (based on the For Loop)ĪctiveDocument.Tables(1).Cell(r, c).Select 'Loop through the 3x3 Source table and simulate sending keys to copy and paste, cell by cell

Copy word table to excel keep formatting