Tim

This is the old adage of 'develop in the lowest used tool'. New Excel 2002
features cannot be backward compatible to an earlier version, as they had
not been thought of or incorporated at that time. You can only avoid using
features in newer versions or upgrade the others. If not you will, at best
not get functionality, at worst, your code will error a lot.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Tim Childs" wrote in message
...
Hi

If I use Excel 2002 for VB at home and then try using the file at work
where
we use Excel 2000, then some functionality does not work properly. For
example, the Replace method has more parameters in Excel 2002.

Is there a way round this: I tried saving to Excel 2000 format but it does
not appear to do the trick

Thanks in advance

Tim