Can't find libraries

M

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top