naturalger.blogg.se

Copy word table to excel merged cells
Copy word table to excel merged cells









copy word table to excel merged cells copy word table to excel merged cells

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?

copy word table to excel merged cells

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?











Copy word table to excel merged cells