Thats because VB uses different reference libraries for Excel 97 and Excel 2000.

Excel 200 uses version 9.0 and I think Excel 97 uses version 5.0.