Distributing a file with a macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Larry K - 16 Nov 2007 18:48 GMT

I've read instructions for distributing macros and must not understand them.

I recorded a macro named "Append" to append files that are in a folder to
the end of a document named CoverPage.doc.

I saved the macro to CoverPage.doc rather than Normal.dot but see also that
it is in Normal.dot.

The macro in CoverPage.doc worked correctly but I need to distribute
CoverPage.doc plus the files that it is supposed to append to other people.

I also saved the file CoverPage.doc to a template named CoverPage.dot

I created a folder named C:\Macros and copied the template CoverPage.dot,
the CoverPage.doc, and the RTF files to be appended to it.

I modified my Options for "File Locations" and "Workgroup Templates" to
C:\Macros and now the macro does not work anymore.

What do I need to correct to be able to distribute the CoverPage.doc with
the macro and the RTF files to other people?

Thanks for any help that can be provided!

Signature

Larry K

Reply to this Message

Graham Mayor - 17 Nov 2007 06:52 GMT

Wouldn't includetext fields be simpler?

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I've read instructions for distributing macros and must not
> understand them.
[quoted text clipped - 22 lines]
>
> Thanks for any help that can be provided!

Reply to this Message

Russ - 19 Nov 2007 10:02 GMT

Larry,
You usually want to start with a blank document and save it as a template
like the first couple of steps at this link.
http://www.dragondrop.com/WordCoding/word011b.asp

Just changing a .doc to a .dot is not the way to do it.
http://word.mvps.org/faqs/customization/WhatTemplatesStore.htm
http://word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm

> I've read instructions for distributing macros and must not understand them.
>
[quoted text clipped - 19 lines]
>
> Thanks for any help that can be provided!

Signature

Russ

drsmN0SPAMikleAThotmailD0Tcom.INVALID

Reply to this Message