R said:
I have a growing collection of macros that I wish to make available when I
launch Word.
I can make a separate ".dot" file in Word's Startup folder for each one
Or
I can put several into a single ".dot" file in that folder
Is there any difference in action taken on Word launch?
Are there any advantages/disadvantages to either policy?
Once you have the macros debugged, I can't think of any real advantages
to putting each macro in a separate templates. Loading the files takes
about the same time, with a single file being slightly more efficient.
Note that each additional file takes overhead resources, so if you don't
have a lot of RAM, it could reduce your performance.
That said, I have several global templates (add-ins) that I use, with
macros grouped by function:
1) My startup add-in, which hides/disables all the built-in toolbars and
menus, and creates my custom replacements. It also contains macros that
set all my preferences, set keyboard shortcuts, substitute for built-in
commands (e.g., setting Window/Arrange All to tile vertically rather
than horizontally), load and unload my Work menu, and a few macros that
implement styles. There's also a macro that sets toolbars, menus,
keyboard shortcuts and preferences back to defaults so that I can quit
and load a stock configuration.
2) A "workbar" add-in, which builds and has macros for my most common
utility macros, such as toggling full path in the caption, cycling
header and numbering levels, resizing windows, setting zoom, showing
document statistics, entering date/time fields in my preferred format,
pasting in my signature, etc.
3) A VB6 replacement add-in, containing VBA5 equivalents for VBA6
functions (e.g., Split, Join, Replace, StrReverse). That way I can code
for VBA6, and simply use a reference to the add-in for Mac versions.
4) An add-in containing about 50 other macros, including ones that do
complex formatting, clean up emails, do file manipulation, generate
labels and form letters, create reports, create complex tables, etc.
I use modules liberally, since you can transfer modules, not individual
macros/procedures using the Organizer. That way if I need to send a
macro to a client, I can grab the module I want and transfer it to a new
template/add-in.
I debug all new macros in a clean document or template, just for ease of
use - that way I can load a clean copy of Word with only my macro, test
it, then try adding the other add-ins.
I never store anything in Normal, since I have an AppleScript that
trashes the Normal template every time I log in, to reduce the
possibility of corruption.