Can't find libraries

[MG]

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 9 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). Once the new
links are made it's not possible to run it on the older version of excel. I
was hoping there maybe a way that the spreadsheet could automatically make
the link to the
appropriate library; new or old. Can this be coded?

 

[Steve Schapel]

MG,

The focus of this newsgroup is Macros in MS Access, the database
programme. Which is not VBA. YOu will probably have a better chance of
a good answer if you re-post in an Excel related forum.