
Signature
Russ
drsmN0SPAMikleAThotmailD0Tcom.INVALID
Hi Russ,
I tried that and the only way that worked is if I have the template opened
at the same time that the third-party program opens a document. THen the
macros work. But if I close the template and only have the document opened
they do not work. It's like the document does not see the ThisDocument
module. Is there a way to force the document to ready the ThisDocument Module?
> Maybe you really want to use a global template?
> See this information. It applies to Windows, too, except for the pathname
[quoted text clipped - 58 lines]
> >> Email cannot be acknowledged; please post all follow-ups to the newsgroup so
> >> all may benefit.
Russ - 07 Oct 2007 20:22 GMT
With the global template method, you for instance put the global template
into each user's Startup folder, like the website said, and whenever that
user's copy of Word starts up, it should 'inherit' all the 'attributes'
(buttons, menus, macros, styles, layout, boilerplate text, autotext, etc.)
of their global template.
Like Jay said, if the third party program is doing something 'out of the
ordinary', then that may break the normal global template method.
You might ask the third party program people whether they have some other
way to replicate the global template method (sometimes called an add-in).
They may limit what macros can be run for security reasons, but they should
have a way to 'sign' trusted macros to allow them to work.
> Hi Russ,
>
[quoted text clipped - 74 lines]
>>>> so
>>>> all may benefit.

Signature
Russ
drsmN0SPAMikleAThotmailD0Tcom.INVALID
Shauna Kelly - 08 Oct 2007 00:07 GMT
Hi
The global template solution from Russ might solve the problem.
If you're using the Document_New or Document_Open events in the ThisWorkbook
module, then another thing to try (instead of - not as well as - the global
template solution) is to replace them with Subs named AutoNew and AutoOpen
in an ordinary module.
In theory, they should work more or less the same. In practice, I sometimes
find the older AutoNew and AutoOpen work more reliably, especially on very
large documents.
(And if that makes a difference, please let us know!)
Hope this helps.
Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word
> Hi Russ,
>
[quoted text clipped - 81 lines]
>> >> newsgroup so
>> >> all may benefit.