Embedding excel field into Word form in order to auto populate.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark - 20 Sep 2004 19:26 GMT

I am creating a form in Word. I would like to be able to
enter a number in a field and the rest of the form auto
populate with the appropriate information from Excel. How
can I do this?

Reply to this Message

Doug Robbins - 22 Sep 2004 00:24 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 am creating a form in Word. I would like to be able to
> enter a number in a field and the rest of the form auto
> populate with the appropriate information from Excel. How
> can I do this?

Reply to this Message

Rate this thread: