Extract MS word data to MS Excel

[GTS]

Hello to all,
now this is a rather complicated task i'd like to do. I have severa
Word files in a specific format (several tables). I'd like to create
macro in an excel worksheet that extracts from ALL Word files (locate
in the same directory) specific values from the tables and then past
them in specific excel columns-rows.
It is quite complicated or at least it seems so to me

Many thanks in advance,
George Tsakalo

 

[Tom Ogilvy]

http://support.microsoft.com/?id=149830
XL: Macro to Link a Range of Cells in Word
(Example of Excel controlling word, but not running a word macro)


http://support.microsoft.com/?id=165926
OFF97: Can't Dimension Word as Application from Other Program
(Examples of Working with Word 97 using OLE)

http://support.microsoft.com/?id=135082
Invalid Page Fault Running VB Macro in Hidden Word Session
(Word 7, when Word is Closed causes a problem)

http://support.microsoft.com/?id=167223
Microsoft Office 97 Automation Help File Available on MSL

 

[GTS]

Thank you very much, but this is not what i've been looking for. I nee
to get data FROM Word TO Excel. I want the macro to find the dat
automatically based on the table column in Word. And finally, the marc
should check all Word documents in a directory and do its task.....toug
huh? sorry, but if you can help...

Regards,
G. Tsakalo

 

[Tom Ogilvy]

I gave you the method to control Word from Excel. If that isn't what you
want, then it is unclear what you want.

You can use the Dir command to find all the word files in a directory (see
the help example for a start) or get voluminous examples searching the
google archive for this group.

As far as searching the documents, you can probably get the code you need by
turning on the macro recorder in Word and performing the actions manually.
then generalize that code and combine with the methods in the articles.