Auto Populate form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

young one - 20 Sep 2004 21:49 GMT

I have a large spreadsheet in Excel with lots of
information (the first column is the ID number. the next
few columns contain information). I would like to create a
form in WORD that will:
1. Allow me to type in an ID number
2. Then the program will auto populate the form with
appropriate information related to the ID number.

Is this possible in WORD?

Thanks for any help.

Reply to this Message

Doug Robbins - 22 Sep 2004 00:20 GMT

If you put the data into Access, then you could use the information in the
article "Access a database and insert into a Word document the data that you
find there" at:

http://word.mvps.org/FAQs/InterDev/GetDataFromDB.htm

If you see the article "How to create a Userform" at:

http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm

and then create a template containing a userform, you could use the
information in the article "Load a ListBox from a Named Range in Excel using
DAO" at:

http://word.mvps.org/FAQs/InterDev/FillListBoxFromXLDAO.htm

To populate a listbox, or a combobox on the userform from which you could
select the ID and have code insert the data into the document.

Or you could make use of the information in the article "Retrieving Data
from a Named Range in Excel using DAO" at:

http://word.mvps.org/FAQs/InterDev/XLToWordWithDAO.htm

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

>I have a large spreadsheet in Excel with lots of
> information (the first column is the ID number. the next
[quoted text clipped - 7 lines]
>
> Thanks for any help.

Reply to this Message