"Error accessing system registry"; can't open sheets with macros

Simon Rogals

unread,

Jan 12, 2003, 9:24:21 AM1/12/03

to

Hi -

I have encountered a problem whereby any spreadsheet I have
which contains a macro will no longer open in Excel X.

I get the message "error accessing system registry". I have
checked to see if any system files are locked, rebooted, checked
the website, emailed microsoft, all to no avail...

Has anyone seen this before?

Thanks,

Simon.

Bob Greenblatt

unread,

Jan 13, 2003, 8:27:06 AM1/13/03

to

in article 415101c2ba46$4c6bb780$8ef82ecf@TK2MSFTNGXA04, Simon Rogals at

Since there is no system registry in Macintosh, my guess is that the
workbook contains a macro written for windows that issues this error. Can
you open the workbook with the shift key down - to prevent auto macros from
running? Do you get the same error?

--
Bob Greenblatt [Excel MVP]
Bobgre...@msn.com
www.bandlassoc.com

Simon Rogals

unread,

Jan 13, 2003, 9:43:24 AM1/13/03

to

Hi Bob,

Thank you for replying to my post.

Yes, I have tried disabling Macros. I think the problem relates to
the installation/operation of VB and macros, rather than to any
specific spreadsheet.

First of all, it occurred suddently. I was able to open these files
previously.

Secondly, I cannot run VB or macros from Word or Excel. I get
errors "Unable to record" (for macros) and "The VB editor could
not be started..." (in word).

Possible reasons given in Word are: 1) not enough free memory
2) files may have been moved or deleted or 3) the VB editor has
not been installed.

I have 784mb RAM and it was working before, so that leaves
option 2 although nothing has been moved, installed or deleted
between it working and not working.

The last thing I did in excel before the problem occurred was to
screen capture parts of my excel project to send to a client.

Thanks again for any help.

Simon.

>.
>

Simon Rogals

unread,

Jan 14, 2003, 6:29:09 AM1/14/03

to

I have encountered a problem whereby any spreadsheet I have
which contains a macro will no longer open in Excel X.
I get the message "error accessing system registry". I have

checked to see if any system files are locked, rebooted, and I
have tried disabling Macros.

I think the problem relates to the installation/operation of VB and
macros, rather than to any specific spreadsheet.

It occurred suddently. I was able to open these files
previously.

I cannot run VB or macros from Word or Excel. I get

J.E. McGimpsey

unread,

Jan 14, 2003, 1:54:16 PM1/14/03

to

Don't know if this will help, but I'd suggest running Fix Disk Permissions
from the First Aid Tab of the Disk Utility (OS 10.2) or from the Repair
Privileges application (OS 10.1.5).

If that doesn't work, I'd suggest trashing

Carbon Registration Database

from the ~/Library/Preference/Microsoft folder (~ being your home directory)

On 01/13/2003 07:43, in article
3c3501c2bb12$208640f0$d2f82ecf@TK2MSFTNGXA09, "Simon Rogals"
<Simon....@ireland.com> wrote:

--
Microsoft MVP/Mac

barnz1

unread,

Feb 6, 2003, 6:43:25 PM2/6/03

to

"J.E. McGimpsey" wrote:
> If that doesn't work, I'd suggest trashing
> Carbon Registration Database
> from the ~/Library/Preference/Microsoft folder (~ being your home directory)

Simon -
I have been having this problem as well, and I have been very
frustrated at not finding any useful fixes. Today, it's fixed. I
updated Office to Service Release 1 (still didn't work) and I trashed
the Carbon Registration Database file, as JE recommends above.
Suddenly, >>KAPOW<< spreadsheets with VB code open just fine.

I had tried to trash many other suspect files, but none had any
effect. I had also run FIX DISK PERMISSIONS, that didn't do it
either. So I would suggest following JE's instruction first, then
looking into other things if that doesn't fix.

Cheers
Barnaby Fry
Oakland, CA
to reach me, use my name "barnaby" (at andiamo design dot net)

J.E. McGimpsey

unread,

Feb 14, 2003, 3:48:19 PM2/14/03

to

On 02/06/2003 16:43, in article
85d84946.03020...@posting.google.com, "barnz1"
<ju...@andiamodesign.net> wrote:

> "J.E. McGimpsey" wrote:
>> If that doesn't work, I'd suggest trashing
>> Carbon Registration Database
>> from the ~/Library/Preference/Microsoft folder (~ being your home directory)
>
> Simon -
> I have been having this problem as well, and I have been very
> frustrated at not finding any useful fixes. Today, it's fixed. I
> updated Office to Service Release 1 (still didn't work) and I trashed
> the Carbon Registration Database file, as JE recommends above.
> Suddenly, >>KAPOW<< spreadsheets with VB code open just fine.
>
> I had tried to trash many other suspect files, but none had any
> effect. I had also run FIX DISK PERMISSIONS, that didn't do it
> either. So I would suggest following JE's instruction first, then
> looking into other things if that doesn't fix.
>

Thanks for the feedback...

--
Microsoft MVP/Mac