Take a look here http://www.xldynamic.com/source/xld.EarlyLate.html

--
---
HTH

Bob

__________________________________________
UK Cambridge XL Users Conference 29-30 Nov
http://www.exceluserconference.com/UKEUC.html

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Noemi" wrote in message
...
Hi

I have an excel spreadsheet which is used on different versions ie 97 &
2000.

I need to be able to email the spreadsheet using a macro however at the
moment I get a compile error.

We are unable to set the library reference on the 97 version because to
save
the form we must run it through 2000 first.

Any idea's what I need to do to set the correct reference using code.

Thanks