Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-04-2014, 09:44 AM
silveredge8181 silveredge8181 is offline macro not saved in normal.dotm Windows XP macro not saved in normal.dotm Office 2003
Novice
macro not saved in normal.dotm
 
Join Date: Jul 2012
Posts: 4
silveredge8181 is on a distinguished road
Default macro not saved in normal.dotm

I recorded some macros in Word, in “All Documents (Normal.dotm)", but they are not being saved across new sessions.



Normal.dotm is located in C:\Users\myname\AppData\Roaming\Microsoft\Templates

I'm running Windows7, a new OS from XP, and Office 10, a new install on the new machine.

As a test I enabled Word Options, Advanced, Save, "Prompt before saving Normal template" ... but am not prompted after creating a macro as described above, then closing word





Thanks in advance.
Reply With Quote
  #2  
Old 06-04-2014, 11:38 AM
Stefan Blom's Avatar
Stefan Blom Stefan Blom is offline macro not saved in normal.dotm Windows 7 64bit macro not saved in normal.dotm Office 2013
Moderator
 
Join Date: Aug 2011
Posts: 3,910
Stefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to all
Default

This suggests that an add-in is preventing the Normal template from saving. You have to troubleshoot for add-ins separately.

As a workaround, though, you should open Normal as a document and record the macro directly in the file. Then save it manually.

To open the template, you can do the following: From within Word, press Alt+F11 and then Ctrl+G, to activate the Immediate window in the Visual Basic Editor. Type

NormalTemplate.OpenAsDocument

and press Enter. Normal opens in a separate window and you should now close the Visual Basic Editor.
__________________
Stefan Blom
Microsoft Word MVP

Microsoft 365 apps for business
Windows 11 Professional
Reply With Quote
  #3  
Old 06-04-2014, 12:35 PM
silveredge8181 silveredge8181 is offline macro not saved in normal.dotm Windows XP macro not saved in normal.dotm Office 2003
Novice
macro not saved in normal.dotm
 
Join Date: Jul 2012
Posts: 4
silveredge8181 is on a distinguished road
Default

Stefan,
Your work around did seem to get the macro into a persistent file. However it automatically showed, some typing I did as a test, whenever I open a new document. Not what I wanted.

I guess I will try to tinker with the Add-Ins.
Reply With Quote
  #4  
Old 06-07-2014, 11:30 AM
Stefan Blom's Avatar
Stefan Blom Stefan Blom is offline macro not saved in normal.dotm Windows 7 64bit macro not saved in normal.dotm Office 2013
Moderator
 
Join Date: Aug 2011
Posts: 3,910
Stefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to all
Default

Just open the Normal template again and delete any content you (accidentally) added to the file. Save and close.

Note that you don't have to use a macro to open Normal; it's just that it makes the task a bit easier, since you don't have to locate the file on your system.
__________________
Stefan Blom
Microsoft Word MVP

Microsoft 365 apps for business
Windows 11 Professional
Reply With Quote
  #5  
Old 06-09-2014, 06:24 AM
silveredge8181 silveredge8181 is offline macro not saved in normal.dotm Windows XP macro not saved in normal.dotm Office 2003
Novice
macro not saved in normal.dotm
 
Join Date: Jul 2012
Posts: 4
silveredge8181 is on a distinguished road
Default

Yes, I was running the macro "in" Normal.dotm and it is a text editing macro that is intended to insert text into the document ... so I needed to do what I did. I just needed to "clean" the document after I had what I needed. Workaround not as good as how base product is supposed to function.

What I really needed was to be able to save macros in Normal.dotm while I am editing some target document.

Solution: I "disabled" all "Action" type Add-Ins, they seemed to be innocuous, and there after recording macros in Normal.dotm worked !

Thanks for your help.
Reply With Quote
  #6  
Old 06-09-2014, 06:48 AM
Stefan Blom's Avatar
Stefan Blom Stefan Blom is offline macro not saved in normal.dotm Windows 7 64bit macro not saved in normal.dotm Office 2013
Moderator
 
Join Date: Aug 2011
Posts: 3,910
Stefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to all
Default

Thanks for the follow-up.

Your description illustrates that you should troubleshoot for the add-in which is causing Normal not to save correctly. See the Knowledge Base article at http://support.microsoft.com/kb/921541/en-us.
__________________
Stefan Blom
Microsoft Word MVP

Microsoft 365 apps for business
Windows 11 Professional
Reply With Quote
  #7  
Old 06-09-2014, 07:23 AM
silveredge8181 silveredge8181 is offline macro not saved in normal.dotm Windows XP macro not saved in normal.dotm Office 2003
Novice
macro not saved in normal.dotm
 
Join Date: Jul 2012
Posts: 4
silveredge8181 is on a distinguished road
Default Save macro using VBA editor

I was wrong in my solution. Add-ins had nothing to do with saving a macro in Normal.dotm. Saving the macro didn't work when I tried again.

So, I re-activated the previously deactivated Add-ins.

I didn't realize the effect that occurred, that additionally I had gone into VBA editor and clicked the save to disk icon after I had recorded the macro. This is what really did the savings. This sounds like a bug to me. p.s. the associated key board command short cut was not saved.

Hope someone else can benefit from my trials.

Last edited by silveredge8181; 06-09-2014 at 10:57 AM. Reason: correct typo #1
Reply With Quote
  #8  
Old 06-09-2014, 11:06 AM
Stefan Blom's Avatar
Stefan Blom Stefan Blom is offline macro not saved in normal.dotm Windows 7 64bit macro not saved in normal.dotm Office 2013
Moderator
 
Join Date: Aug 2011
Posts: 3,910
Stefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to all
Default

Well, the file containing the recorded macro must always be saved; there is nothing strange about that.

By default, Word saves modifications to the Normal template without asking you first. To ensure that you see a prompt, select "Prompt to save Normal template" at Tools | Options | Save.

As you have noticed, you can save manually by clicking the Save icon in the Visual Basic Editor.

However, it's important to figure out why other ways of saving isn't working properly. Troubleshooting add-ins is an important part of that.
__________________
Stefan Blom
Microsoft Word MVP

Microsoft 365 apps for business
Windows 11 Professional
Reply With Quote
  #9  
Old 06-09-2014, 07:58 PM
Charles Kenyon Charles Kenyon is offline macro not saved in normal.dotm Windows 7 64bit macro not saved in normal.dotm Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,154
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Until you figure out which Add-In is causing the problem, one other thing you can do is record your macros as usual (in documents other than the Normal template) saving them in the Normal template. Then open and save the normal template itself before ending the Word session.

Normal Template in Microsoft Word - How to Find or Open the Normal Template
Reply With Quote
Reply

Tags
macro, normal.dotm, word 2010



Similar Threads
Thread Thread Starter Forum Replies Last Post
Set Page Colour in Normal.dotm for Word 2013 SteveWcg Word 2 11-19-2013 02:43 PM
macro not saved in normal.dotm Location of normal.dotm namedujour Word 3 04-25-2013 03:24 PM
macro not saved in normal.dotm Adding macro to normal.dotm programmatically etippelt Word VBA 6 04-08-2013 05:55 PM
macro not saved in normal.dotm New template/New normal.dotm kenglade Word 3 12-19-2011 04:00 PM
macro not saved in normal.dotm How to get to normal.dotm Aiken_Bob Word 4 05-02-2011 02:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:54 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft