dynamic linking/referencing Office libraries

N

NJS

Good Day All
How does one dynaically link/reference another Office library. e.g. If an
Access application needs to use the Excel library in VBA code, how do I
dynamically determine which one is installed/available, e.g. Excel 8/9/10/11
etc, and link use the optimal one? (As opposed to hardwired
'Tools/References')
thanks
 
Top