save macros in other projects other than normal

E

EstherH

Can macros be saved with names other than "normal"?
If yes, is there any way to make macros available to many different files
(grouped in some way)?
 
E

Edward Thrashcort

Can macros be saved with names other than "normal"?

Of course! Just save the file as a template (*.DOT) file

If yes, is there any way to make macros available to many different
files (grouped in some way)?

Either attach your template to the document in place of the "Normal"
template, or install your template as a global add-in


Eddie
 
E

EstherH

Edward,

Thanks. But, the problem is that I can't figure out how to do that.
My macros start in Normal/New Macros. Now what? How do I get part of that
file into a new file connected to only my current document or if possible,
to a series of documents?

I would like to send my documents to others with the macros available. I
would prefer not to have to embed the macros in each of the files. Nor to I
want to send it as "Normal" since that would overwrite the other person's
Normal macros.
 
E

EstherH

Thanks. I have been poking around in this topic and have found some other
good links. I will follow up on them and get back here if I am still left
with questions. You guys are really helpful.
 
J

Jay Freedman

Hi Esther,

There are at least two ways to move your macros from template to template.

1. Create a new blank template. (In Word 2000 and earlier, you could just
click the Template option button in the File > New dialog. In Word
2002/2003, it's easiest to make a new blank document and use the "Save as
type" dropdown in the File > Save As dialog to save it as a template.) Start
the VBA editor. Select the code from the NewMacros module in the Normal
project, and copy it to the clipboard. Click the project of the new
template, click Insert > Module, and paste the code into the code window.
Save the new template.

2. Create a new blank template. Start the Organizer (Tools > Templates &
Add-Ins > Organizer). Click the Macro Project Items tab. Copy the NewMacros
project from Normal.dot to the new template. Close the dialog and save the
template. If necessary, go into the VBA editor and delete macros that aren't
needed there.

One other technique is to record your macros directly into the template
where you want them. If the document that's active when you start the
recorder is based on some template other than Normal.dot, the initial dialog
offers that template in the "Save macro in" dropdown.

When the template contains the correct macros, see
http://word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm for what to do with
it. You may also get some useful hints from
http://word.mvps.org/FAQs/MacrosVBA/ModifyRecordedMacro.htm.
 
E

EstherH

Thanks Jay.


Jay Freedman said:
Hi Esther,

There are at least two ways to move your macros from template to template.

1. Create a new blank template. (In Word 2000 and earlier, you could just
click the Template option button in the File > New dialog. In Word
2002/2003, it's easiest to make a new blank document and use the "Save as
type" dropdown in the File > Save As dialog to save it as a template.) Start
the VBA editor. Select the code from the NewMacros module in the Normal
project, and copy it to the clipboard. Click the project of the new
template, click Insert > Module, and paste the code into the code window.
Save the new template.

2. Create a new blank template. Start the Organizer (Tools > Templates &
Add-Ins > Organizer). Click the Macro Project Items tab. Copy the NewMacros
project from Normal.dot to the new template. Close the dialog and save the
template. If necessary, go into the VBA editor and delete macros that aren't
needed there.

One other technique is to record your macros directly into the template
where you want them. If the document that's active when you start the
recorder is based on some template other than Normal.dot, the initial dialog
offers that template in the "Save macro in" dropdown.

When the template contains the correct macros, see
http://word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm for what to do with
it. You may also get some useful hints from
http://word.mvps.org/FAQs/MacrosVBA/ModifyRecordedMacro.htm.
 
C

Charles Kenyon

See http://addbalance.com/word/movetotemplate.htm for step-by-step
instructions on moving / sharing / copying / backing-up customizations
including AutoText, AutoCorrect, keyboard assignments, toolbars, macros,
etc. You can choose to record macros in templates other than normal.dot
including a particular document template or the document itself. You can
then move them using the visual basic editor to other open projects.
 
E

EstherH

Thanks for the response and the info.
I got to your article
Template Basics in Microsoft Word
in that website by following leads of previous responders.

I will definitely look at it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top