VBA in Template not Document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Trev - 13 Jul 2005 10:04 GMT

I have a VBA embedded into a template, it works fine and I can generate new
documents off the template. However if the document (.doc) is e-mailed or
copied to a new machine the VBA breaks because I cannot find the template.
It is not an option to copy the .DOT as well.

Does anyone know if there is any way to programmability break the link
between a document and a template and copy the VBA / macro code from the
template into the document.

Thanks in advance.

Reply to this Message

Word Heretic - 21 Jul 2005 13:05 GMT

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

Who is the audience please? If this is internal you need a SOE
solution involving a simple XCOPY bat file to copy down the changed
templates at login from a central, accessible location.

If this is external, you can either send the template along, or drag
the vba from the template to the document. However, many
implementations of Word will still forbid your macros for security
reasons. If you send the template and doc zipped together, it works
quite well if you digitally sign your template.

Steve Hudson - Word Heretic

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

Trev reckoned:

>I have a VBA embedded into a template, it works fine and I can generate new
>documents off the template. However if the document (.doc) is e-mailed or
[quoted text clipped - 6 lines]
>
>Thanks in advance.

Reply to this Message