Calling a macro from another template

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

red6000 - 25 Jan 2006 21:07 GMT

Hi,

I have a macro in my 'normal.dot'

I also have another template that loads through the autostart whenever I
start word.

I want to use a macro that is in my normal.dot in some code in 'myother.dot'
when Word loads.

Can I do this?

Thanks

Reply to this Message

red6000 - 25 Jan 2006 21:13 GMT

> Hi,
>
[quoted text clipped - 9 lines]
>
> Thanks

Let me just expand a little. I have a template that loads through the
startup folder and in this template (called APA.dot) I have a module with
the following code: My problem is that 'SysUpdater' is in 'normal.dot' and
not 'apa.dot'.

Sub AutoExec()

Load SysUpdater

If SysUpdater.TextBox1.Value = "250106" Then

MsgBox ("don't update")

Else

MsgBox ("run update")

End If

Unload SysUpdater

End Sub

Reply to this Message

Charles Kenyon - 26 Jan 2006 01:09 GMT

Application.Run MacroName:="MyMacro"

Signature

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

> Hi,
>
[quoted text clipped - 9 lines]
>
> Thanks

Reply to this Message