Word macros failing after installing XP SP2

[Brian Knittel]

I just installed XP SP2 on XP Pro. A bunch of macros that I was using
in Word 97 and Word 2003 immediately before the service pack install are
no longer working. I don't have an exhaustive list of what's not working,
but here are a couple I ran into right away:

left() and mid() are gone. Error is "Can't find Project or Library," thrown
during compilation phase.

The statement

Selection.style = ActiveDocument.Styles("Normal")

gives the error "Could not open macro storage" during execution.

The version of Word is Word 97 SR-2.
Word 2003 11.6113.5606 was installed in a separate directory, long
after installing Word 97. All was fine before XP SP2.

Ironically, I'm trying to write an article about the changes people should
expect to see on installing SP2.

Any advice and direction on this would be greatly appreciated.

Brian

 

[Brian Knittel]

False alarm: macros work correctly when log on as Administrator.
And, renaming "normal.dot" to "normal.old" solves the problem.
So, it appears to be a corrupt normal.dot, not a SP2, issue

 

[Malcolm Smith]

Brian

Rule One. When things go wrong; delete Normal.dot

- Malc
www.dragondrop.com

 

[Word Heretic]

G'day " Brian Knittel" <[email protected]>,

For a start Left() is better off as Left$() and so is mid. However,
they are caused by a missing project reference from Tools > references
in the VBE. So, you USED to have a reference set, now it can't find
that referenced template.

Steve Hudson - Word Heretic
Want a hyperlinked index? S/W R&D? See WordHeretic.com

steve from wordheretic.com (Email replies require payment)


Brian Knittel reckoned: