Global macro to open normal.dot

M

MKG

I'd like to create a macro which will open a user's normal.dot file.

The base file location is the same for everyone; only the UserID contained
in that path will vary. For instance, C:\DOCUMENTS AND
SETTINGS\MKG\APPLICATION DATA\MICROSOFT\TEMPLATES\NORMAL.DOT. The MKG is
what will be different per user.

I get the concept of what I need to do, but I don't know the code.

This is on XP with Word 2003.
 
T

Tony Jollans

Whenever Word is open, the user's Normal.dot is open.

If you really want to open it for editing, this will do it

Templates("Normal.dot").OpenAsDocument

I'd be interested to know what you are actually trying to achieve though.
 
M

MKG

Thank you!

FYI, we started hearing from users that they were unable to save anything to
their normal.dot file. After exhaustive testing and research, the problem
turns out to be due to Adobe Standard or Adobe Pro. Both versions put a
toolbar in Word and it somehow puts a force field around normal so that you
can't do a darned thing to it.

There's no fix as yet, only workarounds, one of which is to open normal and
edit manually. (The other is a reg hack to turn off the toolbar, you make
your changes and then turn it back on - or leave it off).

I thought it would be nice to have a macro that some of our more advanced
users could run, because remembering how to navigate to the file would be too
much to remember for some.
 
T

Tony Jollans

As a workaround you can Hold Shift while clicking on File from the menu,
then Select Save All - this will save everything including Normal.dot. Or
save it explicitly via the VBE. Or ...

Rather than creating a macro to open Normal, why not one to save it - and
put it on a toolbar icon which anybody can then use.

Also I believe there is now a fix available from Adobe. If you haven't
already seen it, check here for a lot of details:
http://www.gmayor.com/lose_that_adobe_acrobat_toolbar.htm
 
M

MKG

Thank you again! Until we get the fix in place, I'm setting up the macro via
a toolbar button for the users who make frequent changes and we manually open
the file for the sometime editors.
 
C

Charles Kenyon

You can also put a command to save normal.dot on the file menu.
Sub SaveNormalMacro()
' Written April 20, 2000 by Charles Kyle Kenyon

If normalTemplate.Saved = False Then
normalTemplate.Save
End If
End Sub

--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide


--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top