(Thanks for the version of the code that works from within word's vba, that will be useful for me in the future at some point, but I also need a version that works while running excel. If a dialog box appears asking if you want to replace the style, click. With the file open, Rosamine selects the entire table (all rows and columns). I want to get the "Sub ImportWordTable()" working, so I can modify it (most likely remove the parts where a user needs to select a document and a table and have them automated). In the Organizer dialog box, click the style on the right you want to copy. Option 2 for Table Integration Select Table. (In Excel 2007, click the Data tab, click Get External Data, and then select. Another quick way to copy format in Excel is by using the keyboard shortcut for Paste Special > Formats. footers in a word-processed document that remain the same for every page. Go to Data Import External Data Import Data. If it's No.1, that could be a problem (The whole point of "Sub ImportWordTable()" is so the user doesn't have to have the desired word document opened.) A format in excel can be defined as the change of appearance of the data in. copy excel table ms word 4 easy ways trump. If it's No.2 that's not a concern, I'll be very familiar with the document I am selecting and the table that needs to be copied. 2 Method To Quickly Enter Same Texts Into Multiple Cells In Your Word Table. Or (No.2) are you saying "users won't know what table to select from within the document unless they're familiar with the document they have selected". (No.1)Are you saying that the above code will only work if the word document with the desired table to be copied, is actively open while the "Sub ImportWordTable()" is ran? Click the upper left cell of the table you have formatted.
If the user has to nominate the table to be processed, that's going to be difficult unless they've already opened the document before running your macro (since they won't be able to scroll the document) in which case, why not just have them select (or at least click in) the table and either run the process from Word or rewrite the Excel code to work with the selection in an already-open document? How to Copy Format Changes From One Table to Another in an Excel Spreadsheet 1.