Excel: "Object Library not registered"?
Stephen R. Anderson
deal with forms prepared in that format, so I don't know much about the
program. Sorry if this is a simple question.
I have a form which I received a while ago. It opens fine in Excel from
Office 2001 (under Classic on my OS X machine), but when I try to open
in in Excel v.X, it starts to load and then bails out with the error
message "Object Library not Registered."
Is this a problem with my installation of Office v.X, or with the form
itself? What can I do about this?
--
Stephen R. Anderson
Prof. of Linguistics and Cognitive Science
Yale University
<stephen....@yale.edu>
Relative0
In response to article <141220011222448718%stephen....@yale.edu>
> I don't use Excel much, except to open files other people send me or to
> deal with forms prepared in that format, so I don't know much about the
> program. Sorry if this is a simple question.
>
> I have a form which I received a while ago. It opens fine in Excel from
> Office 2001 (under Classic on my OS X machine), but when I try to open
> in in Excel v.X, it starts to load and then bails out with the error
> message "Object Library not Registered."
>
> Is this a problem with my installation of Office v.X, or with the form
> itself? What can I do about this?
Suggest that you ensure that you have the same references available in
both versions of Excel (2001 & v.X), by opening the Visual Basic Editor
and selecting Tools>References...
--
Regards, Vaughan Griffiths
eryn...@ubgznvy.pbz (Rot-13 encoded)
Relative Zero Pty. Ltd.
Stephen R. Anderson
Relative0 <eryn...@ubgznvy.pbz> wrote:
As I say, I don't know much about Excel...
I opened the Visual Basic Editor in Excel-2001, and under
"Tools>References..." I found the object library. When I tried the same
thing in Excel-v.X, practically all menu options were grayed out from
the Visual Basic Editor: In particular, I couldn't open
"Tools>References..." at all. Obviously something isn't installed
right, but what? And how do I fix it? I think I installed practically
everything in the "Value Pack" relevant to Excel, but perhaps there's
something I missed.
--Steve Anderson
Stephen R. Anderson
Relative0 <eryn...@ubgznvy.pbz> wrote:
OK, I figured it out. When I looked at the file "Visual Basic for
Applications" in the Office folder, I saw it was identified as a
"Mulberry Carbon plugin." Wierd. I had the mail client Mulberry
installed, though I don't really use it (I use Mail.app, though I might
well use Entourage instead if it knew how to talk to the CommuniGate
Pro 3.5 IMAP server on my other machine...hint, hint). Once I removed
Mulberry, removed and re-installed Office, and re-booted, my problem
went away (and "Visual Basic for Applications" was no longer identified
as anything but a Document).
So there must be some extension/file type conflict between the Visual
Basic file and Mulberry.
--
Steve Anderson
Frank Sanders
141220011222448718%stephen....@yale.edu, "Stephen R. Anderson"
<stephen....@yale.edu> wrote:
> I don't use Excel much, except to open files other people send me or to
> deal with forms prepared in that format, so I don't know much about the
> program. Sorry if this is a simple question.
>
> I have a form which I received a while ago. It opens fine in Excel from
> Office 2001 (under Classic on my OS X machine), but when I try to open
> in in Excel v.X, it starts to load and then bails out with the error
> message "Object Library not Registered."
>
> Is this a problem with my installation of Office v.X, or with the form
> itself? What can I do about this?
I'm having a similar problem. However the entire Tool's menu in the Visual
Basic Editor is greyed out even though "Visual Basic for Applications" is
identified by the operating system as a document.
-fs
Brad Hutchings
Sanders" <margi...@hotmail.com> wrote:
I had this problem as well. After lots of experimenting, here is what I
found out.
At least in my setup, Excel seems to have problems with my home directory
being on a different disk partition than the root OSX partition. I found
this out by creating a temporary user with a home directory on the OSX
partition and found that this user could run Excel with no problems.
So, here is what I did. I took the Carbon Registration Database file that
Is created the first time you run any Office X program and deleted it from
my home directory (it is in ~/Library/Preferences/Microsoft). I then copied
the Carbon Registration Database file from the temporary user directory. I
have been running this way for several days with no problems. Make sure you
are not running any Office programs when you do this. YMMV, no doubt.
Best of Luck,
Brad Hutchings
Matthew Centurión
Matt
On 16-01-2002 12:58 PM, in article B86B376D.320%hu...@ee.byu.edu, "Brad
Hutchings" <hu...@ee.byu.edu> wrote:
>
> I had this problem as well. After lots of experimenting, here is what I
> found out.
>
> At least in my setup, Excel seems to have problems with my home directory
> being on a different disk partition than the root OSX partition. I found
> this out by creating a temporary user with a home directory on the OSX
> partition and found that this user could run Excel with no problems.
>
> So, here is what I did. I took the Carbon Registration Database file that
> Is created the first time you run any Office X program and deleted it from
> my home directory (it is in ~/Library/Preferences/Microsoft). I then copied
> the Carbon Registration Database file from the temporary user directory. I
> have been running this way for several days with no problems. Make sure you
> are not running any Office programs when you do this. YMMV, no doubt.
>
> Best of Luck,
>
> Brad Hutchings
>
--
Check out all the Microsoft Mac Newsgroups at:
http://www.microsoft.com/mac/support/newsgroups.asp
Check out product updates and news & info at:
http://www.microsoft.com/mac