How can I set Custom DOC Properties in Word from Excel
 

I have a worksheet with quite a few values that need to be included in
word document.

At present these values are typed into the Custom Properties Dialo
manually and referenced throughout the document with the "insert field
option. This saves me re-typing the value every time it is mentioned
and reduces the chance of a copy error.

Is there a way to make Excel write "Custom Document properties" to
word document. I would like to press a button in excel and have it sen
all the values to the open word document, so I can switch to word an
all the custom fields are set.

Thanks

Stuar

--
Stu7
-----------------------------------------------------------------------
Stu78's Profile: http://www.excelforum.com/member.php...fo&userid=1360
View this thread: http://www.excelforum.com/showthread.php?threadid=39291