How to extract data from Word document directly into Excel?

Questions › Category: Office › How to extract data from Word document directly into Excel?

1 Vote Up Vote Down

Anonymous asked 2 years ago

Hi!
I was wondering if is there any possibility to extract data from one or multiple Word documents into Excel?
For example, there are some template documents with specific tables at specific chapters (e.g. Test reports with test statuses). Is there any possibility to automatically scan the documents and get some data from there (e.g. Test passed/failed)?

Thank you!

Question Tags: excel, office, office 2010, windows

1 Answers

0 Vote Up Vote Down

Bogdan Staff answered 2 years ago

Hi!
you can create a macro to perform that action. Check here more info about this topic:
http://social.msdn.microsoft.com/Forums/en-US/af6953fd-22bb-4b97-93c9-e7a4177c1f52/extracting-data-from-word-table-into-excel-2010-suite-and-vba-macro?forum=worddev