Problem executing macros from global template

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Arlan - 29 Jun 2005 06:52 GMT

After creating a new template in Word 2002 then saving it
in the word\startup folder then adding it in Global
Templates and Add-ins I can access the custom toolbar in
any new document. But, when I access any control that uses
a macro it says "compile error in hidden module:
modulename." It works before saving it as a template.
What is happening?

THANKS!

Reply to this Message

Word Heretic - 29 Jun 2005 14:47 GMT

G'day "Arlan" <Arlan@discussions.microsoft.com>,

Load said global, use Tools > Compile and it will take you to the
syntax error.

Steve Hudson - Word Heretic

steve from wordheretic.com (Email replies require payment)
Without prejudice

Arlan reckoned:

>After creating a new template in Word 2002 then saving it
>in the word\startup folder then adding it in Global
[quoted text clipped - 5 lines]
>
>THANKS!

Reply to this Message

Arlan - 30 Jun 2005 18:51 GMT

It seems that the problem is that the reference to the MS DAO object
disappears when it is saved as a template. Is this a feature (AKA bug) in
VBA or is there something more basic that I am missing?

> G'day "Arlan" <Arlan@discussions.microsoft.com>,
>
[quoted text clipped - 17 lines]
> >
> >THANKS!

Reply to this Message

Cindy M -WordMVP- - 01 Jul 2005 09:30 GMT

Hi =?Utf-8?B?QXJsYW4=?=,

> It seems that the problem is that the reference to the MS DAO object
> disappears when it is saved as a template. Is this a feature (AKA bug) in
> VBA or is there something more basic that I am missing?

A reference shouldn't disappear when you simply save a template. Are you
certain you're setting the reference with the focus in the correct project?

You say "when IT is saved as s template". What is "IT"?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

Reply to this Message

Word Heretic - 05 Jul 2005 03:40 GMT

G'day "Arlan" <Arlan@discussions.microsoft.com>,

Keep a dummy userform in your project.

Steve Hudson - Word Heretic

steve from wordheretic.com (Email replies require payment)
Without prejudice

Arlan reckoned:

>It seems that the problem is that the reference to the MS DAO object
>disappears when it is saved as a template. Is this a feature (AKA bug) in
[quoted text clipped - 21 lines]
>> >
>> >THANKS!

Reply to this Message