how can I pull to value from a excel spreadsheet in the text of a word document?

[drjohncooper]

I'm writing a long word document where I want to include code values and descriptor from an excel spreadsheet. I need to place a large number of code and descriptors with in the text of the document and cut and pasting is not going to be efficient.


My text would look something like this... "we have received comments on

, <descriptor> but we believe that ,<descriptor> is more appropriate for the condition.


So what I would like to do is have these placeholders in the text of my word document so that when i type in a code the descriptor is inserted into the document from the excel spreadsheet.


The spreadsheet is looks like this...

code	long descriptor

00560	Anesthesia for procedures on heart, pericardial sac, and great vessels of chest;

00561	Anesthesia for procedures on heart, pericardial sac, and great vessels of chest;

00562	Anesthesia for procedures on heart, pericardial sac, and great vessels of chest;

00563	Anesthesia for procedures on heart, pericardial sac, and great vessels of chest;

00566	Anesthesia for direct coronary artery bypass grafting; without pump oxygenator

 

[Luke M]

Hi drjohncooper,


Good news is that it certainly is doable. I think the solution stated here:

http://www.mrexcel.com/forum/excel-questions/57449-excel-word-possible.html


should be able to help you out. Involved just establishing links for each cell. Downside is that it's manually setup, not a "lookup" type function. Let us know if this will work, or if we need to explore other options.

 

[drjohncooper]

this helpful but I guess i was probably looking more towards a mail merge of look up type function as I have a large number of codes to input in the document.

 

[NARAYANK991]

Hi ,


What you are looking for can be done using bookmarks and VBA ; is this acceptable to you ?


Some references :


1. http://www.wiseowl.co.uk/blog/s199/word-bookmarks.htm


2. http://visualbasic.about.com/od/learnvba/a/aa030103.htm


3. http://word.mvps.org/faqs/macrosvba/WorkWithBookmarks.htm


Narayan