Exporting from word to excel

[Guest]

I have a tabular word file ( table is 2 columns and rows making the document
16 pages long). Now i want to search the Word document for any occurance of a
specific word (eg. data) and for all the occurances of that word(data) the
cell in which 'data' was found should get exported to a cell in an excel
workbook. Just want to know if there is any way i could do this.

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?U2hlcmk=?=,

I have a tabular word file ( table is 2 columns and rows making the document
16 pages long). Now i want to search the Word document for any occurance of a
specific word (eg. data) and for all the occurances of that word(data) the
cell in which 'data' was found should get exported to a cell in an excel
workbook. Just want to know if there is any way i could do this.

you'd definitely need a macro. The various bits and pieces (doing a "Find" in
the whole document; connecting to Excel) are described in articles on the
word.mpvs.org website.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail