I currently set a reference in the VBE (Tools References) to a
database api dll but some users of the spreadsheet will not have access
to the directory at which the dll is located so an an error is
returned.
Is there a way to set the reference at run time once I have determined
whether or not the directory exists?

Something like References.AddfromFile "C:\Server\MyDll.dll"


Any suggestions gratefully received.
Thanks
Simon