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?
|
Similar Threads
