Thanks Tom and Harlan too. I'm currently working from home just now and only
have this third hand but I'm told that when running in a 97 environment the
macros trashed the machine!!!! I think I'm going to have to ask the guy to
get in touch with these forums etc to see if he can find an easy way through
this!
DaveG

"Tom Ogilvy" wrote:

No converter. He need to get xl97 and run the macro - making corrections
when it halts.

Depending on how sophisticated the code is:

Most will be eliminating arguments that are not supported in xl97 (assuming
he did a lot of macro recording). He will need replacements for things like
Split, Replace and some other functionality introduced in VBA 6 (xl97 uses
VBA 5).

--
Regards,
Tom Ogilvy


"daveginboav" wrote:

My supplier has written some macros in Excel 2003 without checking with us
first what version we were running. He has managed to get them working on
Excel 2000 but we need them to work in Excel 97. 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?