| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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... |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help locating Object Libraries | Excel Discussion (Misc queries) | |||
| How do i insert an outlook msg file object in excel | Excel Worksheet Functions | |||
| How do I import Outlook email into Excel, as object? | Excel Discussion (Misc queries) | |||
| QUICK PLEASE Outlook object Reference name | Excel Programming | |||
| Object libraries | Excel Programming | |||
Hybrid Mode
