VBA to bind references

[luvbite38]

Hi All,

Is there a way to attach the VBA references on opening the workbook. The users of my workbook can be both excel 2003 users and excel 2010 users.

I want my macro, when you open this specific workbook. Check the Application version and if the version is 2003, than attch Microsoft ActiveX Data Objects xx Library and Microsoft ActiveX Data Objects (Multi-dimensional) xx Library and if 2010 than Microsoft ActiveX Data Objects xx Library and Microsoft ActiveX Data Objects (Multi-dimensional) xx Library.
Where xx is relevant version no. for each 2003 and 2006.

Please help

 

[shg]

You could instead use late binding and Excel would use the newest library.