How can I use Excel VBA to determine the AutoCAD versionin use and then automatically load the appropriate reference files?

I have set up a spread sheet that allows Project Managers to define the layout for electrical enclosures.

Running this on my PC, I can create a drawing in about 10 seconds that would normally take about 4-5 hours.

What I need now if for this spread sheet to be able to be used on any version of AutoCAD without the user needing to manually load the library reference files.

I have spent about 3 days searching the net trying to find the relavent code but it seems very allusive so I would appreciate any help that anyone may be able to provided