O
Ounbbl
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.
that I can use them on re-installed Office.
Thank you.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob I
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.
(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.
O
Ounbbl
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.
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.
B
Bob I
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)
2003 Tools, Macros, Macro, you look in the "Macros in" box. (Macros are
only text, and typically don't take much space)
O
Ounbbl
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.
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.
B
Bob I
Sorry, I don't have Word 2007, so I can't tell you the results of your
file version conversions.
file version conversions.
D
Dian D. Chapman, MVP
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/Pub0009/LPMArticle.asp?ID=151
Sharing Macros
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.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
and also how to share marcros with others or transfer to another
machine.
Normal.dot Template-Explained
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=151
Sharing Macros
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.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