Automatizing table-copying in Excel, selecting just one column

Hello, I’d need some help in automatizing a task in Excel: I have multiple (around 600) Word documents with a table in them (3 columns, with the first row dedicated to the titles of the columns, which are the same in every Word document). What I need, is for Excel to copy the content of the 3rd column cells of every Word document, in a row of Excel for every word file. Is it possible? What would the macro code look like?

Thank you in advance to anybody willing to spend some time helping me out, I'd really appreciate it!

· 4

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CeasarChenMSFT-3458 · Apr 21 at 02:53 AM

Hi,
I'm working on it and will reply when there is progress.

1 ·

TB736-9496 CeasarChenMSFT-3458 · Apr 21 at 11:04 AM

Hi,

Thank you very much for your time!

0 ·

emizhang-msft · Apr 21 at 09:23 AM

Hi @TB736-9496,
Your problem is related to VBA code in Office, I added the office-vba-dev tag.
The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.