Start Macros enabling and updating

Macros enabling and updating

If you are like most people, after you find/create and start using your first macro you may soon find yourself with dozens, if not hundreds or more.

Just open a new Word document and save it as (Word 2003) or macro-enabled (Word 2007 and higher).

I recommend saving one in Word's startup folder to load automatically when Word starts for general macros that you use frequently (e.g., My Frequent Macros.dotm) and another to your templates folder that you can loaded manually when you need it for the macros that you only occasionally or seldom use (e.g My Dusty Macros.dotm).

Word8.0) Update: 11-Dec: It seems that for a few cases so far, this solution doesn’t resolve the issue.

I will post back if and when I discover a solution for those cases too, though simply uninstalling the update mentioned at the beginning of this post may be a solution until a fix is released.

The VBA procedure (procedure, routine or macro) shown below performs the common and often requested task of updating document fields. See the section Organizing Your Macros/Template Add-Ins below for more information. If not displayed, press CTRL r (or use the VBE "View" menu and select "Project Explorer") to display the top left "Project" pane. If not displayed, press F4 to do display the bottom left "Properties" pane. Use the drag bar between the panes to adjust as appropriate. The large white panel on the right is the "Code" pane. The macro is created in a new standard module "New Macros." The module is stored in the modules folder as part of the Normal template.

It can be used in all versions of Word (Word 97 through 2013). As you realize the benefits of macros and install more or begin creating your own you will want to organize your macros for more efficient management.

That should open explorer to the Temp folder and you then need to look in the Excel8.0 and VBE folders for the files.

(if your issue is with a program other than Excel, look for the folder related to that application – e.g.

This can result from line wrapping in the e-mail editor or other source editor.

This issue can be fixed by joining the broken line in one of two methods: There is almost always more than one way to skin a cat.

We will use it as a representative example macro in the discussion that follows. See the section Organizing Your Macros/Template Add-Ins below for more information.