how to loop through all the words in a document query a database to see if word or phrase exist in database

How can I loop through all the words in a microsoFt WORD DOC AND CHECK IF THAT WORD OR A PHRASE EXISTS IN an excel database and then either replace the word with another from the database or insert a particular picture whose [ath is in the database
Dov_BAsked:
Who is Participating?
 
[ fanpages ]Connect With a Mentor IT Services ConsultantCommented:
Hi,

As I queried in a remarkably similar question from 6 June 2013:

[ http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_28149909.html#a39226799 ]

Would it be feasible/practical to copy'n'paste the text from the MS-Word document into a separate worksheet within the MS-Excel workbook so that the comparison can be performed in one application?

BFN,

fp.
0
 
Dov_BAuthor Commented:
not realy
0
 
[ fanpages ]IT Services ConsultantCommented:
OK.

Can you clarify what you mean by "an excel database", please?
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
Dov_BAuthor Commented:
a list of words in a column sorry for calling it a database
0
 
[ fanpages ]IT Services ConsultantCommented:
:)

How is a replacement word to be determined?

I presume there are actually two columns; one of a list of words, & another adjacent with a list of paths.

Perhaps the provision of a sample file would be useful.
0
 
Dov_BAuthor Commented:
I presume there are actually two columns; one of a list of words, & another adjacent with a list of paths.
Yes
0
 
[ fanpages ]IT Services ConsultantCommented:
Abandoned thread?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.