No VBA editor

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

adam - 22 Apr 2005 17:07 GMT

Well, fifteen minutes ago I was going to ask how to repair my
installation of Office 2004. Neither Word nor Excel would allow me to
open the VBA editor - I got errors stating either that "macro storage
could not be opened" or something to the effect that VBA was not
installed.

But I searched the group first, and found a post from about a year ago
that pointed to this document:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;272347

Now, you can't exactly follow the steps in that document since it was
written for Office 98. In fact, of the six files that its Method 1
suggest deleting, I could only find two in Office 2004 ("Microsoft OLE
Automation", and "Microsoft OLE Library" - actually, I found just
"Microsoft OLE" instead of the latter). But I moved them to a new
folder, and archived the folder anyway, to see if it would help.

Word crashed immediately upon launch.

Then I unarchived the originals and put them back from whence they
came.

Word and Excel both gladly offer up the VBA IDE now.

Weird? Yes. Maybe it'll help someone else though.

Signature

Adam Wuellner

Reply to this Message

Jim Gordon MVP - 23 Apr 2005 18:13 GMT

Hi Adam,

That's great detective work and it is also great that you took the time
to post the information here. You will undoubtedly save some folks a lot
of time and they will be grateful to you (probably not enough to send
money to you, though).

This sounds like a permissions problem. Had you run Apple's Disk Utility
to repair permissions before switching the files in and out?

-Jim

Signature

Jim Gordon
Mac MVP
MVP FAQ
<http://mvp.support.microsoft.com/default.aspx?scid=fh;EN-US;mvpfaqs>

> Well, fifteen minutes ago I was going to ask how to repair my
> installation of Office 2004. Neither Word nor Excel would allow me to
[quoted text clipped - 21 lines]
>
> Weird? Yes. Maybe it'll help someone else though.

Reply to this Message

adam - 25 Apr 2005 20:05 GMT

re:
"This sounds like a permissions problem. Had you run Apple's Disk
Utility to repair permissions before switching the files in and out? "

No, not immediately prior to trying the steps I indicated. This was,
however, a long-standing problem with my Office installation, and I had
tried repairing permissions at least a couple of times in
troubleshooting this problem in the past.

I had also done that step recently anyway, prior to installing the Mac
OS X 10.3.9 update.

- Adam

[Apologies for the format of this message. I am using Google's Groups
and have to say I'm rather disappointed with the message composer. I
can't believe it does not quote back the parent message.]

Reply to this Message

Mac Forum / Applications / MS Office / April 2005

No VBA editor