The problem:

o Excel VBA workbook developed on Windows 2000 using/referencing Microsoft
ADO Ext. 2.7 for DLL and Security library

o Load and save workbook on Windows XP system

o Re-open the workbook on Windows 2000 system and VBA won't run as it's
missing the reference to Microsoft ADO Ext. 2.8 for DLL and Security library

What's happening is that when it's opened on the Windows XP system, Excel is
automatically upgrading the reference to v2.8 of the library. This is then
saved in the workbook meaning it can't be opened/used with an earlier
version of the library.

Actually, Windows 2000/XP isn't the issue - it would happen on two Windows
2000 systems if they had different versions of the library.

The same doesn't happen with plain ADO - we reference v2.5 and this stays as
v2.5 even when used on Windpws XP running a later version of ADO.
Interesting, the file name for ADOX v2.7 and v2.8 is the same: c:\program
files\common files\shared\ado\msadox.dll

Is there a fix??

Thanks, Rob.