Use Late binding

See Dick's site for a explanation
http://www.dicks-clicks.com/excel/olBinding.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kevin" wrote in message ...
I am using Excel to e-mail via outlook, however I need the
same Excel file to be usable under Excel 97 and 2000.
However to do this I need to use the Object Library, which
differs for 97 and 2000 (V8.0 and 9.0 respectively). Excel
2000 automatically updates V8 to V9, so is forwards
compatible, however it is then saved as V9, which isn't
backwards compatible for V8 in 97.

I don't suppose anyone else has had this problem and knows
a work around? Any way to load the Object Library within
VB depending on the application version being run?

Many thanks...