Extract MS word data to MS Excel
 

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

--
Message posted from http://www.ExcelForum.com

Extract MS word data to MS Excel
 

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

--
Regards,
Tom Ogilvy

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

Many thanks in advance,
George Tsakalos


---
Message posted from http://www.ExcelForum.com/

Extract MS word data to MS Excel
 

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

--
Message posted from http://www.ExcelForum.com

Extract MS word data to MS Excel
 

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.


--
Regards,
Tom Ogilvy

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

Regards,
G. Tsakalos


---
Message posted from http://www.ExcelForum.com/