Auto Fill help

[Oldkleebs]

I am trying to set up something along these lines in Word 2003 and am not
honestly sure of even where to start. Basically I have a word document that
has fields that need to be autofilled. The kicker is that I need to have
some sort of system where I type in an identifier number which pulls info
from and excel sheet attached to that number and that info autofills the
fields in the word doc. Is this something I can do or am I going to need an
entire different program? My boss thinks I am able to do this with the word
system we have, but Im walking in the dark right now. Any help is greatly
appreciated

 

[Jay Freedman]

What you propose can be done with Word (and Excel, working together). It will
require custom programming of a macro -- it can't be done just with the commands
and buttons available in the programs. Unfortunately, if you've never written a
macro before, this is not a good place to start.

If you want to get some background, try reading some of these articles:

http://www.word.mvps.org/FAQs/MacrosVBA/VBABasicsIn15Mins.htm

articles on forms and automation:
http://www.computorcompanion.com/LPMArticle.asp?ID=22
http://www.computorcompanion.com/LPMArticle.asp?ID=46
http://www.computorcompanion.com/LPMArticle.asp?ID=119

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


--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so all
may benefit.