Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Sep 2002
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    runtime error 5981 (97 SR-1)

    I m getting an error message: runtime error 5981. Could not open macro storage. Doc does contain macros from a known/trusted source. The only thing I could find in the MS KB said to remane normal.dot, and try opening the file again. No luck. Any help would be appreciated...Neil

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: runtime error 5981 (97 SR-1)

    Another thing to try is to re-install VBE.DLL. You need to have your Office 97 CD-ROM available for this. See the third method in OFF97: Errors Starting Visual Basic Editor.

    You can also try the steps outlined in <!post=Systematic Approach to Behavioral Problems in Word (97/2000),197827>Systematic Approach to Behavioral Problems in Word (97/2000)<!/post>.

  3. #3
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: runtime error 5981 (97 SR-1)

    Another thing that can cause this error: When one sets up a VBA project in a document or template, it will automatically refer to certain external files that come with MS Office. However, the programmer can add references to other files, for example, a file that stores controls (like a drop-down calendar that lets you pick dates) or a file that contains functions for working with database files. If a referenced file does not exist on your computer, then you can get this (unhelpful) error. If no other technique works to open this file, ask the sender to remove all references other than the standard ones (Office, Word, VBA, and OLE) and see if that helps.

  4. #4
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Zoetermeer, Zuid-Holland, Netherlands
    Posts
    559
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: runtime error 5981 (97 SR-1)

    I encountered the same error when opening a file with a (ore more) Sub/Function with the same name as a Sub/Function in a add-in. Temporarily de-installing the add-in and renaming the offending Sub/Function cured the problem.

    Jan

Posting Permissions

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