No VBA editor

[adam]

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.

 

[Jim Gordon MVP]

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

 

[adam]

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.]