saving macros for exporting

Before re-installing MS Office, how can I save all the macros I have made so
that I can use them on re-installed Office.
Thank you.

Macros are stored in files. The two primary (default)ones are Normal.dot
(Word)and personal.xla (Excel) But you can put them in whatever files
you want when you create them. So you will need to save the files you
have stored macros in.

Ounbbl wrote:

> Before re-installing MS Office, how can I save all the macros I have made so
> that I can use them on re-installed Office.
> Thank you.

Bob I

Thank you. I am using only Word (2007). You are telling me that I should
save that .dot files and use it again on another Word (in different computer
or after re-installing MS Word)? I am curious that innocuous looking .dot
file has all the macros (several) I have created?

Oun.

"Bob I" wrote:

> Macros are stored in files. The two primary (default)ones are Normal.dot
> (Word)and personal.xla (Excel) But you can put them in whatever files
> you want when you create them. So you will need to save the files you
> have stored macros in.
>
> Ounbbl wrote:
>
> > Before re-installing MS Office, how can I save all the macros I have made so
> > that I can use them on re-installed Office.
> > Thank you.
>
>

If THAT is where you saved them it is. I am not using Word 2007, but in
2003 Tools, Macros, Macro, you look in the "Macros in" box. (Macros are
only text, and typically don't take much space)

Ounbbl wrote:

> Bob I
>
> Thank you. I am using only Word (2007). You are telling me that I should
> save that .dot files and use it again on another Word (in different computer
> or after re-installing MS Word)? I am curious that innocuous looking .dot
> file has all the macros (several) I have created?
>
> Oun.
>
> "Bob I" wrote:
>
>
>>Macros are stored in files. The two primary (default)ones are Normal.dot
>>(Word)and personal.xla (Excel) But you can put them in whatever files
>>you want when you create them. So you will need to save the files you
>>have stored macros in.
>>
>>Ounbbl wrote:
>>
>>
>>>Before re-installing MS Office, how can I save all the macros I have made so
>>>that I can use them on re-installed Office.
>>>Thank you.
>>
>>

I have somehow normal.dot showing up with a wrong font (Calibri 11 point - I
don't know how it got there). I made my template. When I changed normal.dot
to normalx.dot and mytemplate.dot as normal.dot, the macros become disabled.
I had to revert back to normal.dot.

I wonder how I can make mytemplate as the default one while preserving
macros.
If you can help on this one.

By the way I did not save that way, it was saved that way.

Oun.


"Bob I" wrote:

> If THAT is where you saved them it is. I am not using Word 2007, but in
> 2003 Tools, Macros, Macro, you look in the "Macros in" box. (Macros are
> only text, and typically don't take much space)
>
> Ounbbl wrote:
>
> > Bob I
> >
> > Thank you. I am using only Word (2007). You are telling me that I should
> > save that .dot files and use it again on another Word (in different computer
> > or after re-installing MS Word)? I am curious that innocuous looking .dot
> > file has all the macros (several) I have created?
> >
> > Oun.
> >
> > "Bob I" wrote:
> >
> >
> >>Macros are stored in files. The two primary (default)ones are Normal.dot
> >>(Word)and personal.xla (Excel) But you can put them in whatever files
> >>you want when you create them. So you will need to save the files you
> >>have stored macros in.
> >>
> >>Ounbbl wrote:
> >>
> >>
> >>>Before re-installing MS Office, how can I save all the macros I have made so
> >>>that I can use them on re-installed Office.
> >>>Thank you.
> >>
> >>
>
>

Sorry, I don't have Word 2007, so I can't tell you the results of your
file version conversions.

Ounbbl wrote:

> I have somehow normal.dot showing up with a wrong font (Calibri 11 point - I
> don't know how it got there). I made my template. When I changed normal.dot
> to normalx.dot and mytemplate.dot as normal.dot, the macros become disabled.
> I had to revert back to normal.dot.
>
> I wonder how I can make mytemplate as the default one while preserving
> macros.
> If you can help on this one.
>
> By the way I did not save that way, it was saved that way.
>
> Oun.
>
>
> "Bob I" wrote:
>
>
>>If THAT is where you saved them it is. I am not using Word 2007, but in
>>2003 Tools, Macros, Macro, you look in the "Macros in" box. (Macros are
>>only text, and typically don't take much space)
>>
>>Ounbbl wrote:
>>
>>
>>>Bob I
>>>
>>>Thank you. I am using only Word (2007). You are telling me that I should
>>>save that .dot files and use it again on another Word (in different computer
>>>or after re-installing MS Word)? I am curious that innocuous looking .dot
>>>file has all the macros (several) I have created?
>>>
>>>Oun.
>>>
>>>"Bob I" wrote:
>>>
>>>
>>>
>>>>Macros are stored in files. The two primary (default)ones are Normal.dot
>>>>(Word)and personal.xla (Excel) But you can put them in whatever files
>>>>you want when you create them. So you will need to save the files you
>>>>have stored macros in.
>>>>
>>>>Ounbbl wrote:
>>>>
>>>>
>>>>
>>>>>Before re-installing MS Office, how can I save all the macros I have made so
>>>>>that I can use them on re-installed Office.
>>>>>Thank you.
>>>>
>>>>
>>

See these two TechTrax articles for details about how Normal.dot works
and also how to share marcros with others or transfer to another
machine.

Normal.dot Template-Explained
http://pubs.logicalexpressions.com/P...cle.asp?ID=151

Sharing Macros
http://pubs.logicalexpressions.com/P...cle.asp?ID=166

However, note that the above articles have not yet been updated for
2007. So in 2007, understand that your default Normal template is
called Normal.dotx because it now uses an XML architecture. When it,
or any document or template have macros inserted into them, the file
format changes and becomes .dotm, which designated that macros are now
contained. You cannot change the file extension. If you do, the macros
will not run. This is a safety feature to prevent hidden virus macros
from running without your knowledge.

You can use the Organizer to transfer macros to another template that
can then be given to others.

In 2007, the organizer can be found under the Developer's tab >
Document Templates > Organizer. Then it works the same as detailed in
the above articles.

Note that the Developer's tab is not turned on by default, so to
see/use it you need turn it on. To do this, click Office button > Word
Options > Popular and check the option to SHOW developer's tab on
ribbon.


Dian D. Chapman
Technical Consultant, Microsoft MVP
MOS Certified Instructor, Editor/TechTrax Ezine
Tech Editor for Word & Office 2007 Bibles
https://mvp.support.microsoft.com/profile/Dian.Chapman

Free PC Tutorials: http://www.mousetrax.com/techtrax
Free Word Tricks eBook: http://www.mousetrax.com/books.html
Optimize your business docs: http://www.mousetrax.com/consulting
Learn VBA the easy way: http://www.mousetrax.com/techcourses.html




On Fri, 28 Sep 2007 07:35:01 -0700, Ounbbl
<Ounbbl@discussions.microsoft.com> wrote:

>
>I have somehow normal.dot showing up with a wrong font (Calibri 11 point - I
>don't know how it got there). I made my template. When I changed normal.dot
>to normalx.dot and mytemplate.dot as normal.dot, the macros become disabled.
>I had to revert back to normal.dot.
>
>I wonder how I can make mytemplate as the default one while preserving
>macros.
>If you can help on this one.
>
>By the way I did not save that way, it was saved that way.
>
>Oun.
>
>
>"Bob I" wrote:
>
>> If THAT is where you saved them it is. I am not using Word 2007, but in
>> 2003 Tools, Macros, Macro, you look in the "Macros in" box. (Macros are
>> only text, and typically don't take much space)
>>
>> Ounbbl wrote:
>>
>> > Bob I
>> >
>> > Thank you. I am using only Word (2007). You are telling me that I should
>> > save that .dot files and use it again on another Word (in different computer
>> > or after re-installing MS Word)? I am curious that innocuous looking .dot
>> > file has all the macros (several) I have created?
>> >
>> > Oun.
>> >
>> > "Bob I" wrote:
>> >
>> >
>> >>Macros are stored in files. The two primary (default)ones are Normal.dot
>> >>(Word)and personal.xla (Excel) But you can put them in whatever files
>> >>you want when you create them. So you will need to save the files you
>> >>have stored macros in.
>> >>
>> >>Ounbbl wrote:
>> >>
>> >>
>> >>>Before re-installing MS Office, how can I save all the macros I have made so
>> >>>that I can use them on re-installed Office.
>> >>>Thank you.
>> >>
>> >>
>>
>>