user form automation

S

SilverSpider

i created a user form in word
it asked if a particular file should be opened or not...
ok now for the problem. how to make it run as soon as word is opened.
user form name is dialog
thank you...
 
J

Jonathan West

Hi SilverSpider

Call the form from a macro called AutoExec. Make sure that the form and the
AutoExec macro are together either in normal.dot or in an add-in in Word's
startup folder.
 
S

SilverSpider

yes thanks mr.west

if it would be possible for you to write down the code and pass it to me then it would be ver helpful (considering i am just 16 and a rookie at this)
 
J

Jonathan West

SilverSpider said:
yes thanks mr.west

if it would be possible for you to write down the code and pass it to me
then it would be ver helpful (considering i am just 16 and a rookie at this)

Its not that hard, and you can consider this as a learning experience :)

These articles might help you

What do I do with macros sent to me by other newsgroup readers
to help me out?
http://word.mvps.org/FAQs/MacrosVBA/CreateAMacro.htm

How to get the most recently used document to be opened
automatically when you open
http://word.mvps.org/FAQs/Customization/OpenMostRecentlyUsed.htm

Distributing macros to other users
http://word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm

Getting To Grips With VBA Basics In 15 Minutes
http://word.mvps.org/FAQs/MacrosVBA/VBABasicsIn15Mins.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top