drop down form

[Need help]

I want to create a drop down form in which one can choose
the name of something. Lower on the document, depending on
the name, I'd like it to lookup the address in an Excel
workbook, and import that information to the Word document.
How do I go about doing this?

 

[Cindy M -WordMVP-]

Hi Need,

I want to create a drop down form in which one can choose
the name of something. Lower on the document, depending on
the name, I'd like it to lookup the address in an Excel
workbook, and import that information to the Word document.
How do I go about doing this?

Well, it would require VBA; trigging from the dropdown list,
I'd say. You'd have the choice of using an ActiveX control or
a form field (if you're creating a protected form).

You should find code on connecting to and communicating with
Excel at word.mvps.org

For any followup, I suggest you post to an appropriate
word.vba newsgroup.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
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