Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Preventing automatic upgrade of references to ADO
The base standard for ADO on a Windows 2000 PC is ADO v2.5. Therefore, we
develop our Excel based application referencing this version. However, Excel has a very annoying habit of automatically upgrading references to ADO in the following situation: o Developer saves with reference to v2.5 o User A with ADO v2.7 opens the workbook o Excel upgrades the ADO reference to v2.7 (even though v2.5 is also on there) o User A saves the workbook o User B with basic Windows 2000 PC (thus v2.5) tries to open workbook but can't as it references a library they don't have I realise we could use late binding but that really slows down development as intellisense doesn't work and therefore typos occur. So... a) is it possible to disable this automatic upgrading (I suspect not)? b) is it possible to access the referencing mechanism during start-up to force binding back to v2.5? Thanks, Rob. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Preventing automatic upgrade of references to ADO
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Preventing automatic upgrade of references to ADO
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Preventing automatic upgrade of references to ADO
Hi
Thanks for your quickly reply! Anyway if you still have any concern, please feel free to post here and we will follow up you. 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic update to SUM formula cell references. | Excel Worksheet Functions | |||
Automatic Update of Linked Cell References | Excel Discussion (Misc queries) | |||
How to convert all 3d references to normal references in a workboo | Excel Discussion (Misc queries) | |||
Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
How to rename references from range names to cell references | Excel Discussion (Misc queries) |