Hi

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.

2. We can use VBE object modal to add/delete reference.
Programming the Microsoft Office Visual Basic Editor
http://msdn.microsoft.com/library/de...us/dnofftalk/h
tml/office07042002.asp

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.