I have an application that gets deployed to several
different computers (with different OS and Excel
versions). Within the Excel application there are several
macros. I need to use many of the supplied Excel
library's. I add a reference to them, and compile my
project. I even have a function that searches to find any
missing libraries, it them removes the missing libraries
and readd's them by using both the name and the GUID.
Unforntunatley, if the library reference name is
unrecongized by a different version of Excel, it will not
perform the correct actions. Instead, it will leave it
missing. When this happens, all following libraries
(whether missing or not) are not recongnized, and
therefore, my excel application produces an application
error.
I was thinking that I should create some DLL or something
to prevent this from happening, but I am having no luck. I
have had this problem for a really long time, and could
use any form of advice that anyone has.

Thanks in advance!