Global macro to open normal.dot

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MKG - 21 Feb 2006 16:56 GMT

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.

Reply to this Message

Tony Jollans - 21 Feb 2006 17:36 GMT

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.

--
Enjoy,
Tony

> I'd like to create a macro which will open a user's normal.dot file.
>
[quoted text clipped - 6 lines]
>
> This is on XP with Word 2003.

Reply to this Message

MKG - 21 Feb 2006 18:04 GMT

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.

> Whenever Word is open, the user's Normal.dot is open.
>
[quoted text clipped - 18 lines]
> >
> > This is on XP with Word 2003.

Reply to this Message

Tony Jollans - 21 Feb 2006 18:41 GMT

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

--
Enjoy,
Tony

> Thank you!
>
[quoted text clipped - 34 lines]
> > >
> > > This is on XP with Word 2003.

Reply to this Message

MKG - 24 Feb 2006 18:37 GMT

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.

> 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
[quoted text clipped - 56 lines]
> > > >
> > > > This is on XP with Word 2003.

Reply to this Message

Charles Kenyon - 24 Feb 2006 19:18 GMT

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

Signature

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

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
--------- --------- --------- --------- --------- ---------
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.

> Thank you!
>
[quoted text clipped - 40 lines]
>> >
>> > This is on XP with Word 2003.

Reply to this Message

Rate this thread: