Using Outlook Object Libraries V8 & 9
 

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

Using Outlook Object Libraries V8 & 9
 

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

Using Outlook Object Libraries V8 & 9
 

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