Excel 2000 and 2002

[Tim Childs]

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 Hodge]

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
(e-mail address removed)

 

[Tim Childs]

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)

 

[Tom Ogilvy]

Recently.

--
Regards,
Tom Ogilvy

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)