word userform using xl database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

via135 - 11 Apr 2007 05:19 GMT

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

Reply to this Message

Cindy M. - 23 Apr 2007 14:33 GMT

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
[quoted text clipped - 4 lines]
>
> 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 :-)

Reply to this Message