Link a word drop down field "text" to an excel cell

  • Thread starter Thread starter amcferron
  • Start date Start date
A

amcferron

I have a simple form in Word with a drop down menu with 6 text options.
I would like to link that field to an excel file where I was going to
assign each text a value to allow calculations.

When I try to link I only get "0".

Is this possible...is there a better way to do it?
 
I have a simple form in Word with a drop down menu with 6 text options.
I would like to link that field to an excel file where I was going to
assign each text a value to allow calculations.

When I try to link I only get "0".

Is this possible...is there a better way to do it?
Click to expand...
This is not directly possible, no. It would require macro programming, so
it might be just as "simple" to program all the calculations, rather than
automating Excel "on the side".

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)
 
Back
Top