1. Based on my knowledge, there is no such an option. But based on my
test,
the reference to ADO 2.5 workbook will not upgrate to ado2.7 automatically
even if that machine installed ado2.7.

Well it certainly happens here :-)

2. We can use VBE object modal to add/delete reference.
Programming the Microsoft Office Visual Basic Editor

http://msdn.microsoft.com/library/de...ce07042002.asp

Thanks - that looks like it should do the trick.

Thanks, Rob.