User late binding. Declare the Outlook objects as type Object.

"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...