Run Word Doc against Excel lookup table?

S

spmnky

Can anyone please point me toward resources that would help me script a
macro/VB routine to do the following:

1) search a word doc for one of two strings (str1, str2)
2) collect the next word after that string (str3)
3) match that collected string against a column in a table in an excel
workbook
4) if the string hits (it could only hit once) on a row, collect two
strings from other cells in that row (str4, str5).
5) return results in the bottom of the word doc that would basically
say "str3 has been str4 since str5"

I used to write a decent amount of VB stuff in access, so I'm assuming
I could handle this task, if I could get my head around the right way
to approach it in word.

Thanks
 
H

Helmut Weber

Hi,

these are too many questions at once.

To get you started with searching for
the first occurence of one of two strings,
see:

http://tinyurl.com/dexor

Greetings from Bavaria, Germany
Helmut Weber, MVP WordVBA
"red.sys" & chr(64) & "t-online.de"
Word 2002, Windows 2000
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top