Hi all,

I have a workbook with some additional references, specifically:
Microsoft ActiveX Data Objects (Multi-dimensional) 2.8 Library
Microsoft ADO Ext. 2.8 for DDL and Security

And this works just fine on my computer.

However, when some other users utilise the functions that require these
references, they get a compile error, due to missing references. When I go
into it on their pc, I find that they have the above references only to 2.5
or 2.7 available, so have to manually alter the references on the copy
they're using to the earlier version, at which point it works fine for them.
Until they re-open it and try to use it again....

Is there any way around this short of trying to badger IT into giving us all
the same versions of Excel (which, to be honest, would be more work than
going to their desk every time they use it and manually updating them....).
If I set these references to the earliest version 2.5, would users who have
2.7 or 2.8 be able to use it ok, or would they be gettinng compile errors as
they don't have 2.5 specifically?

Many Thanks folks
DS