


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. 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?

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?
