Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    VBA IDE refuses to appear (VBA office sr2 97)

    The VBA environment is not opening at all in the office applications.
    In word it errors with "Cannot open Macro Storage".
    In Excel the IDE will just not appear.
    I am using ALT+F11 to try and access the IDE

    Originally it started as an error appearing when opening a workbook with macros, the error said something along the lines of Compile error, cannot use library.
    When I checked the code it was failing on first function (Ucase).
    I checked the library location in the share folder "C:Program FilesCommon FilesMicrosoft SharedVBA" and copied a known good vba332.dll into the workstations folder.
    Still no joy.

    In the XLStart folder there are no files.

    Office has been re-installed a couple of times in attempt to fix.

    Any help would be appreciated.

    TIA
    Alan
    Cheshire

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

    Re: VBA IDE refuses to appear (VBA office sr2 97)


  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: VBA IDE refuses to appear (VBA office sr2 97)

    Thanks Hans.

Posting Permissions

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