Results 1 to 13 of 13
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Marietta, Georgia, USA
    Posts
    296
    Thanks
    9
    Thanked 4 Times in 4 Posts

    Shrink normal.dot? (Word 2000 SR2)

    As mentioned in several other messages in this forum, poorly written add-ins can cause normal.dot to be saved when exiting from Word. I just determined for a friend today that Microsoft Word in Works Suite 2000 Add-In has been saving her normal.dot every time she exited Word for the last nine months.

    Her normal.dot has ballooned from 35K to 900K in size. We would like to get this back down to a reasonable size. She has lots of stuff in normal.dot, with numerous keystroke assignments to the macros. I probably have to export the VBA code to various text files, and then reconstruct normal.dot.

    One stumbling block is that I don't know how to re-assign keyboard shortcuts after I have imported the VBA code into a "clean" normal.dot. Is there any automated process for doing this? The existing normal.dot has over thirty-five different keyboard shortcuts for its macros.

    I also thought of another potential shortcut method. I tried using the Macro Organizer to copy everything from the 900K normal.dot into a "clean" normal.dot. But this did not keep the keyboard shortcuts for all the macros.

    Maybe I missed an option ... any help would be greatly appreciated.
    Rick Groszkiewicz
    Life is too short to drink bad wine (or bad coffee!)

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Shrink normal.dot? (Word 2000 SR2)

    Instead of making a new Normal.dot from scratch, make a copy of the existing Normal.dot and re-name it Abnormal.doc. Open Abnormal.doc and delete everything you don't want. Save the file, exit Word, delete Normal.dot and rename Abnormal.doc to Normal.dot.

    When you next open Word, it'll use the new smaller Normal.dot, with all the retained macros and keystroke assignements intact.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. #3
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Shrink normal.dot? (Word 2000 SR2)

    A macro can be used to copy keyboard shutcuts to the new template.

    In general, other than the usual Auto* macros, little should be kept in the Normal template AND the Normal template could be made read-only (unless you have 3rd party add-ins that barf in hat situation).

    Macros and autotext can be kept in 1, or more, global templates in Word's StartUp directory.

    Styles should be in application specific templates that get attached to documents, in Normal as a last resort.

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Marietta, Georgia, USA
    Posts
    296
    Thanks
    9
    Thanked 4 Times in 4 Posts

    Re: Shrink normal.dot? (Word 2000 SR2)

    I tried that suggestion, but it made no difference. I still end up with a 900K file, which contains the same macros as the older, much smaller file.

    By using Tools / Macro / Macros / Organizer, I can successfully shrink the normal.dot file. But I lose the keyboard assignments for the macros.
    Rick Groszkiewicz
    Life is too short to drink bad wine (or bad coffee!)

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Marietta, Georgia, USA
    Posts
    296
    Thanks
    9
    Thanked 4 Times in 4 Posts

    Re: Shrink normal.dot? (Word 2000 SR2)

    Howard, I agree that you should not clutter Normal.dot. I don't store stuff there myself, but use MyMacros.dot instead. I'm trying to help someone else with this particular problem.

    Can you give me a hint re:
    "A macro can be used to copy keyboard shortcuts to the new template."

    I am new to VBA / Word, but have many years of experience in Visual Basic and VBA / Excel.
    Rick Groszkiewicz
    Life is too short to drink bad wine (or bad coffee!)

  6. #6
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Shrink normal.dot? (Word 2000 SR2)

    Hi Rick:
    Download Shortcut Organizer, by Chris Woodman, "the feature that Microsoft forgot". It will do just what you need.

  7. #7
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Marietta, Georgia, USA
    Posts
    296
    Thanks
    9
    Thanked 4 Times in 4 Posts

    Re: Shrink normal.dot? (Word 2000 SR2)

    Phil, thanks for the tip! I downloaded the Shortcut Organizer file, read all the documentation, and set it up. It has shown me a lot of information that is really useful.

    I tried using it to copy the macros Several times. Shortcut Organizer looks like it copies most (not all) the macros to Normal.dot. But when I reload Word, the macros are NOT there. It appears that the Normal.dot I am dealing with is corrupted somehow, and makes the Shortcut Organizer fail.

    Looks like I'll have to study KeyBindings, and roll my own VBA code. It is beginning to look like this file may not be salvageable.
    Rick Groszkiewicz
    Life is too short to drink bad wine (or bad coffee!)

  8. #8
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Shrink normal.dot? (Word 2000 SR2)

    Hi Rick:
    I'm not sure what your setup is, but why don't you search your hard drive for normal.dot & see if there's more than one. Also, maybe you're copying the macros to a different template. I haven't used the Shortcut Organizer for a long, long time & don't have it where I am right now to check it.

    Try it as an experiment with a brand new normal.dot & maybe 2 macros with key assignments to see what happens.

    Hope this helps.

  9. #9
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Marietta, Georgia, USA
    Posts
    296
    Thanks
    9
    Thanked 4 Times in 4 Posts

    Re: Shrink normal.dot? (Word 2000 SR2)

    I am happy to report that Shortcut Organizer works like a charm. It was a simple case of user error. <img src=/S/doh.gif border=0 alt=doh width=15 height=15>

    I used Word's Macro Organizer to copy the macros to a new Normal.dot file. Then I used Shortcut Organizer to copy the keystroke assignments.

    Phil, thanks so much for your assistance, and persistence.
    Rick Groszkiewicz
    Life is too short to drink bad wine (or bad coffee!)

  10. #10
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Shrink normal.dot? (Word 2000 SR2)

    If you are an experienced VB and Excel VBA user, then I suggest getting a copy of STeve Roman's Writing Word Macros.

    the code for accessing keybinding should be just about identical in Excel and Word VBA, so you could check your Excel VBA books. Steve Roman also has an Excel VBA book, but John Walkenbach's seem to be the most often recommended.

  11. #11
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Shrink normal.dot? (Word 2000 SR2)

    Shortcut Organizer was written in WordBasic.
    THat will not likely do te deed in Word 97, Word 200, and Word 2002 as WB is brain dead compared to VBA.

    Indeed, just the othe rday, I completed the last bit of WB to VBA conversion on a project that I've been working on (off and on) for 6+ years. THe WB was about 20000 lines of complex code.

    The stuff for menus, keys, toolbars is quite different.
    I'd not use any WB based code in this area,

  12. #12
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Marietta, Georgia, USA
    Posts
    296
    Thanks
    9
    Thanked 4 Times in 4 Posts

    Re: Shrink normal.dot? (Word 2000 SR2)

    I purchased Steve Roman's book "Writing Word Macros", and found it very helpful. It is my main resource for Word VBA programming.
    Rick Groszkiewicz
    Life is too short to drink bad wine (or bad coffee!)

  13. #13
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Marietta, Georgia, USA
    Posts
    296
    Thanks
    9
    Thanked 4 Times in 4 Posts

    Re: Shrink normal.dot? (Word 2000 SR2)

    Howard, I was skeptical when I read that Macro Organizer was written in WordBasic. But it worked like a charm under Word 2000.

    I have some old WordBasic code which I should convert. It takes some research to find the "VBA way" that is equivalent to some of the old WordBasic commands.
    Rick Groszkiewicz
    Life is too short to drink bad wine (or bad coffee!)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •