How can I copy A word Documents information into Excel?

Question

I have a regulated user input template in Microsoft Word. The end goal is to have a DB that captures all of the data collected through these Word forms. 

There are two tables in the templated file. To my understanding they're both labeled "Table 1". I'm just wondering if there's a very descriptive macro out there such as an idiot proof one where I'd only have to input the name of the work doc, excel file, paths, etc in the comments of the actual code. Therefore I'd literally only have to manipulate the VBA slightly by adding the table names, file names, paths, etc.

Any help would be greatly appreciated. 

Answer 1

See, for example:

https://www.excelguru.ca/forums/showthread.php?8900-Help-with-VBA-to-extract-data-from-Word-to-Excel&p=36586&viewfull=1#post36586

https://www.excelguru.ca/forums/showthread.php?8900-Help-with-VBA-to-extract-data-from-Word-to-Excel&p=36594&viewfull=1#post36594

Both macros there are Excel macros for extracting table data from all documents in a selected folder: The 1st from all tables in the documents; the 2nd from just the 1st and 6th tables in the documents.

---

Cheers
Paul Edstein
[MS MVP - Word]

Answer 2

Hello,

I'm confused about what you want to do now. What could we do for you? Could you please provide some examples to detail us what should we do?.

Thanks for understanding,

Best Regards,

Terry

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].