Cannot load VBA to record macro

[Go Blue]

HI,

I cannot load VBA to record a macro on any of the office
programs on my computer. Any ideas are welcome!
details below:

I have OSx 10.2. office v.X 10.1.5.
The error that I receive: from excel=>tools=>macro=>vba
editor:
Microsoft Visual Basic
'Visual Basic for Applications\4' could not be loaded
and then
out of memory
(This still occurs when no other program is open, so I
assume it's not really a memory problem...)

I have tried unistalling and reinstalling the entire office
package but it didn't help.
I have no problem opening the RealBasic editor, but still
cannot record macros.

Thanks.

 

[Jim Gordon MVP]

Hi,

My first thought is to run Disk Utility First Aid and repair permissions.

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Search for help with the free Google search Excel add-in:
<http://www.rondebruin.nl/Google.htm>

 

[J.E. McGimpsey]

I cannot load VBA to record a macro on any of the office
programs on my computer. Any ideas are welcome!
details below:

I have OSx 10.2. office v.X 10.1.5.
The error that I receive: from excel=>tools=>macro=>vba
editor:
Microsoft Visual Basic
'Visual Basic for Applications\4' could not be loaded
and then
out of memory
(This still occurs when no other program is open, so I
assume it's not really a memory problem...)

I have tried unistalling and reinstalling the entire office
package but it didn't help.
I have no problem opening the RealBasic editor, but still
cannot record macros.

IIRC, that library is in the Microsoft Office X:Office:Visual Basic
for Applications shared library. If you've updated to 10.1.5, it
should also be at version 10.1.5 (build 030814).

If you didn't use the Remove Office application to uninstall Office,
it may also be a preference file. Try, with all Office Apps closed,
renaming the ~:Libraryreferences:Microsoft folder. Start XL to
create a new one. If it works, try adding back preferences from
other apps. Ones that I'd suspect:

Carbon Registration Database
Microsoft Component Preferences
Microsoft Office Settings (10)
Office Registration Cache X

 

[Guest]

And the winner is...

it may also be a preference file. Try, with all Office Apps closed,
renaming the ~:Libraryreferences:Microsoft folder. Start XL to
create a new one. If it works, try adding back preferences from
other apps. Ones that I'd suspect:

Carbon Registration Database

Thank you very much!!!
I truly appreciate your help.

Can you recommend any resource for learning more about the
function of carbon registration database? (i.e., what have
I lost from reverting to a new copy of it).

 

[J.E. McGimpsey]

Can you recommend any resource for learning more about the
function of carbon registration database? (i.e., what have
I lost from reverting to a new copy of it).

I don't know of any resource. Generally, the CRD contains
information about the local environment, including where Office apps
and components are located on your machine (since VBA is an
application, that's why trashing the corrupted CRD and rebuilding it
solved your problem). There's nothing there that should affect your
settings/use.

You can open it in either TextEdit or a hex editor to get a feel for
what's stored there. Some of it will appear to be pure gibberish,
some will be more intelligible. I'd recommend not saving it, or
working on a copy.