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

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

Nick

Thanks for this - would that life were so easy: the best place to work is at
home where the XP is!!

Also at work there is no Help available on the PC's - I must hassle out IT
people to get that rectified...

Thanks for your help, tho I sound ungrateful :)

Tim

PS when did Microsoft change the ir CDO object to put the e-mail address as
anonymous etc (I tried putting an e-mail addreess along with my name in the
first field and it blew up - typical Microsoft)

"Nick Hodge" wrote in message
...
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

Recently.

--
Regards,
Tom Ogilvy

Tim Childs wrote in message
...
Nick

Thanks for this - would that life were so easy: the best place to work is
at
home where the XP is!!

Also at work there is no Help available on the PC's - I must hassle out
IT
people to get that rectified...

Thanks for your help, tho I sound ungrateful :)

Tim

PS when did Microsoft change the ir CDO object to put the e-mail address
as
anonymous etc (I tried putting an e-mail addreess along with my name in
the
first field and it blew up - typical Microsoft)

"Nick Hodge" wrote in
message
...
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