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 :-)
 
You must log in or register to reply here.

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

Similar Threads

MS Word Drop-Down list linked to outside source? 2
Drop down menu in Word 2003 1
Logical tests between Word form text fields 1
Drop down questions for Word 1
linking fields to appear in two difference documents 1
Drop-Down Menu Form Field 5
Drop Down Form Field 3
Drop Down Form Field 1

Back
Top