Recovering macros from corrupt normal.dot

[Shirley Pipitone]

I have written about 8 macros so far to convert text survey responses to a
consistent format table of about 1150 rows and 23 columns. They have all
compiled properly. However when I ran the last one Word crashed. I have now
restored the original normal.dot and renamed the crashing version
NormalMacros.dot. But Word crashes instantly whenever I try to open that
template or access the macros in it.

The macros weren't particularly complex - the last one had two actions in a
DO loop repeated 21 times. Why has this problem happened?

I have text copies of most of the macros but not the last big one. Is there
any way I can access the macros in NormalMacros.dot without using Word so I
can recover the last one. Or maybe Word can't cope with such a big table.

Any suggestions would be most appreciated.

Shirley

 

[Graham Mayor]

If open and repair (little arrow at the side of the open button in the file
open dialog) don't fix it and you can't open it in the Organizer (ALT+F8 >
Organizer) then no you cannot access it.

See also http://www.gmayor.com/what_to_do_when_word_crashes.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Helmut Weber]

Hi Shirley,

make a copy of NormalMacros.dot and rename it NormalMacros.txt.
Open it with Wordpad and see, whether there are any remainders
of your macros.

--

Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Vista Small Business, Office XP

 

[NOPIK]

NormalMacros.dot. But Word crashes instantly whenever I try to open that
template or access the macros in it.

http://support.microsoft.com/kb/247028

 

[NOPIK]

You can also try to open file with OpenOffice or similar programs,
that could import VBA code