daveginboav wrote...
....
Upgrading is not an option for all sorts of reasons. Do we send him
back to the drawing board or is there a reasonable quality converter
that could do the majority of work for him - tweaking the bits later
that still did not work?

It may not be possible for your supplier to know what did and didn't
change between Excel 97 and Excel 2000. There were some changes in the
Excel object model, but the big change was in VBA itself. Excel 97
uses VBA 5.x while Excel 2000 and later use VBA 6.x. The difference is
mostly in added functions in VBA itself, such as Join, Split, Replace,
InStrRev. There are work-alikes written in VBA that could be found in
the Google Groups archives for this newsgroup.