Can't find project of library

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MG - 18 May 2008 20:35 GMT

I've developed a spreadsheet with macros in an older version of excel. When
I bring it into a newer version of excel, the macros fall down immediately
with the following error message: Compile error: Can't find project or
library. Is there a way of automatically loading the appropriate libraries
when the spreadsheet is opened?

Reply to this Message

Gord Dibben - 18 May 2008 21:07 GMT

Check to see which one(s) are missing.

You may not even have them available.

Open VBE and Tools>References to have a look.

Could be a reference to an Add-in no longer available or any number of items.

Gord Dibben MS Excel MVP

>I've developed a spreadsheet with macros in an older version of excel. When
>I bring it into a newer version of excel, the macros fall down immediately
>with the following error message: Compile error: Can't find project or
>library. Is there a way of automatically loading the appropriate libraries
>when the spreadsheet is opened?

Reply to this Message

MG - 18 May 2008 22:22 GMT

With the old version of excel it references version 7 of the libraries,
however the new one operates with version 11. Although it is possible to
make the new link it is a problem as you have to go through a lot of
debugging (gets into a loop that takes a while to get out of) and if other
people use the file they will have the same problem. I was hoping there
maybe a way that the spreadsheet could automatically make the link to the
appropriate library. Can this be coded?

> Check to see which one(s) are missing.
>
[quoted text clipped - 11 lines]
> >library. Is there a way of automatically loading the appropriate libraries
> >when the spreadsheet is opened?

Reply to this Message

Gord Dibben - 19 May 2008 00:06 GMT

I'm not too good at that sort of thing.

You might have better luck posting over in the excel.programming group but could
be one of the brighter bulbs will see this and come to assist.

Gord

>With the old version of excel it references version 7 of the libraries,
>however the new one operates with version 11. Although it is possible to
[quoted text clipped - 19 lines]
>> >library. Is there a way of automatically loading the appropriate libraries
>> >when the spreadsheet is opened?

Reply to this Message