So I am using an excel sheet to transfer small amounts of data to a backend access database using ADODB - and to do this we need to set a reference to 'Microsoft ActiveX Data Objects x.x Library'. I typically try and use the most recent version but some of the machines here are somewhat older and may only have 2.0 / 2.1
so I was wandering if anybody knows a trick to check if certain references are available and enable the appropriate one (basically I want to run a sub from workbook_open to check if 2.8 is present, if so enable it, if not check for 2.7 and so on...)
any pointers would be gladly appreciated!
Bogzla
so I was wandering if anybody knows a trick to check if certain references are available and enable the appropriate one (basically I want to run a sub from workbook_open to check if 2.8 is present, if so enable it, if not check for 2.7 and so on...)
any pointers would be gladly appreciated!
Bogzla