Word to excel then result back to word?

Ok, I have an excel worksheet setup with client names, from b2 to b10, and right next to them in column c c2-c10 i have their associated id#'s, and in a2 I have a vlookup that looks up the value in a5 (names) in b2-b10 and when it finds the name it returns the value from c2 to c10 (id#).

What I am looking to do is have a5, the name to lookup come from the name entered hopefully in any of our word documents. Is this possible?

Originally Posted by Andy Pope

Should be possible with code *IF* you can determine the name to lookup in the Word file.
Where abouts in the doc will the name be?
How do you know which word file to look in?

The word file will be the current one open. The excel file will be the "database" to look up the client id# from the name entered in the name spot in the current word doc.

I really do not know all the "functionality" of word, so how do you name a "range" in word? Pretty much every word file we use, has
Name : or just Name (without the colon)

If there is a way to assign a named range the to the word "Name" in the word docs I will do that if necessary.

The spot in the word docs where the name will go is labeled Client

Thanks

Originally Posted by Andy Pope

You can use a bookmark to well bookmark a place in the document from where you can read/write information.

You can search the forum for example of getting a reference to a running word application.
Here is an example of writing from excel to wrod bookmark.
http://www.dailydoseofexcel.com/arch...tomating-word/

Now would the method used i that example work without having to open the excel sheet manually each time a word document is being used?
I am trying to make this process as transparent as possible, because these word documnets are used several times a day by different users.

Thanks for all yoru help.