Not sure I understand your question.

If you use late binding, ADO simply needs to be present on oher users' Pc
and your code will work. If you use early binding, the reference to the same
object as on your machine must be possible: i.e. your users must have the
same version of ADO as you.

I'd use late binding and avoid all the early binding issues.

"KS Wong" wrote:

Hi,

I am writing a data entry sheet in Excel to store data in cells to a
database file. This entry sheet would be given to people using different
computers to enter their data respectively. This entry form would probably
not work if it is not making reference to ADO objects. The problem is : how
could I know, programmatically, whether it is making reference to the ADO
objects and how could I set reference, also programmatically, to ADO objects.

Thanks in advance!