Use Macro on Document Open to Fill In data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lee Howell - 29 Jul 2007 19:36 GMT

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?

Reply to this Message

Doug Robbins - Word MVP - 29 Jul 2007 20:42 GMT

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

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

Signature

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

>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
[quoted text clipped - 7 lines]
> the
> template and then be querried for everything. Can this be done?

Reply to this Message

Russ - 29 Jul 2007 23:31 GMT

Lee,
<http://word.mvps.org/faqs/macrosvba/DocumentEvents.htm>

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

Signature

Russ

drsmN0SPAMikleAThotmailD0Tcom.INVALID

Reply to this Message