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?

Check to see which one(s) are missing.

You may not even have them available.

Open VBE and ToolsReferences 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


On Sun, 18 May 2008 12:35:00 -0700, MG wrote:

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?

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?

"Gord Dibben" wrote:

Check to see which one(s) are missing.

You may not even have them available.

Open VBE and ToolsReferences 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


On Sun, 18 May 2008 12:35:00 -0700, MG wrote:

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?

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

On Sun, 18 May 2008 14:22:06 -0700, MG wrote:

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?

"Gord Dibben" wrote:

Check to see which one(s) are missing.

You may not even have them available.

Open VBE and ToolsReferences 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


On Sun, 18 May 2008 12:35:00 -0700, MG wrote:

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?