Use Macro on Document Open to Fill In data

[Lee Howell]

I am setting up a sheet with client data on it. For reasons I'm not going
into now, the prime users of this sheet are not familiar with and will not us
the address book. This means that most of the repetitive data has to be
typed in, prefferable without forgetting any. I would like to use a macro
and fields that querry for each item. I have that part working, but don't
know how to make the macro execute when the document opens, without the user
have to do anything. I would like for the users to click open and select the
template and then be querried for everything. Can this be done?

 

[Doug Robbins - Word MVP]

See the article "How to create a Userform" at:

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


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Russ]

Lee,

I am setting up a sheet with client data on it. For reasons I'm not going
into now, the prime users of this sheet are not familiar with and will not us
the address book. This means that most of the repetitive data has to be
typed in, prefferable without forgetting any. I would like to use a macro
and fields that querry for each item. I have that part working, but don't
know how to make the macro execute when the document opens, without the user
have to do anything. I would like for the users to click open and select the
template and then be querried for everything. Can this be done?