word userform using xl database

[via135]

i'm having xl database which is to be extracted to a word document
record by record of my choice with the help of a user form. for
example the two filed names in xl data base are "acno" and "amount".

in the word document if i input the acno with the help of userform the
corresponding amount should be picked up.

can somebody give me the code and help..?

regds!

via135

 

[Cindy M.]

Hi Via135,

i'm having xl database which is to be extracted to a word document
record by record of my choice with the help of a user form. for
example the two filed names in xl data base are "acno" and "amount".

in the word document if i input the acno with the help of userform the
corresponding amount should be picked up.

can somebody give me the code and help..?

A starting point would certainly be the two articles on the
word.mvps.org website about controlling Word from Excel and vice
versa... I believe you'll also find an article there about using ADO and
OLE DB to access database information for use in Word. The advantage to
that is Excel doesn't have to be opened or even installed on the
machine.

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