| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Library Reference files
I have an Excel template that invokes a session of
Outlook, which uses the msoutl9.olb reference file. If a user has a different version of outlook (outlook 10), the reference file appears to update to msoutl10.olb and when this is received by a user that has outlook 9, a compile error displays when running the code and the "Missing reference" appears in the references. I have to uncheck and reselect outlook 9 library file to get this to run. Any ideas how I can maintain this template when various users have different versions of outlook? I thought it might work if I loaded both library files on the "administers" computer. Thanks for your help Cindy |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Library Reference files
Hi Cindy
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 "Cindy" wrote in message ... I have an Excel template that invokes a session of Outlook, which uses the msoutl9.olb reference file. If a user has a different version of outlook (outlook 10), the reference file appears to update to msoutl10.olb and when this is received by a user that has outlook 9, a compile error displays when running the code and the "Missing reference" appears in the references. I have to uncheck and reselect outlook 9 library file to get this to run. Any ideas how I can maintain this template when various users have different versions of outlook? I thought it might work if I loaded both library files on the "administers" computer. Thanks for your help Cindy |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Library Reference files
Ron,
Does the same concept apply to all library reference files in Excel because now another problem arose with the "ActiveX Recordset" library file. Please help if you can. Thanks Cindy -----Original Message----- Hi Cindy 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 "Cindy" wrote in message ... I have an Excel template that invokes a session of Outlook, which uses the msoutl9.olb reference file. If a user has a different version of outlook (outlook 10), the reference file appears to update to msoutl10.olb and when this is received by a user that has outlook 9, a compile error displays when running the code and the "Missing reference" appears in the references. I have to uncheck and reselect outlook 9 library file to get this to run. Any ideas how I can maintain this template when various users have different versions of outlook? I thought it might work if I loaded both library files on the "administers" computer. Thanks for your help Cindy . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Library Reference files
Hi
Not all but for this one you must use Late binding also Cindy The default references change to the Excel version you open it in. Sometimes you can select a lower version number to avoid a problem For example the Microsoft ActiveX Data Objects ? library If you use 2.5 it will run in 2000 and higher -- Regards Ron de Bruin http://www.rondebruin.nl "Cindy" wrote in message ... Ron, Does the same concept apply to all library reference files in Excel because now another problem arose with the "ActiveX Recordset" library file. Please help if you can. Thanks Cindy -----Original Message----- Hi Cindy 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 "Cindy" wrote in message ... I have an Excel template that invokes a session of Outlook, which uses the msoutl9.olb reference file. If a user has a different version of outlook (outlook 10), the reference file appears to update to msoutl10.olb and when this is received by a user that has outlook 9, a compile error displays when running the code and the "Missing reference" appears in the references. I have to uncheck and reselect outlook 9 library file to get this to run. Any ideas how I can maintain this template when various users have different versions of outlook? I thought it might work if I loaded both library files on the "administers" computer. Thanks for your help Cindy . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Library Reference files
Yes, I found out the hard way that the references change
with a newer version but don't change back when opened in the older version. I did go back and install the 2.5 recordset .dll on the user's computer as a "temporary" fix. Here's the big pictu This Excel app is used by our local admin staff, 18 regional managers throughout the country, 4 national sales managers, and possibly distributors. So, in that, it's difficult to control what versions of software each person has and when they get upgraded computers I will not always be aware of this. Can I use late binding for all the references I need or will only certain ones create a problem? Here's what I have checked: Visual basic for applications Microsoft Excel 9.0 Object Library OLE Automation Microsoft Office 9.0 Object Library Microsoft Forms 2.0 Object Library Microsoft ActiveX Data Objects 2.5 Library Microsoft ActiiveX Data Objects Recordset 2.5 Library Microsoft Outlook 9.0 Object Library AND...where do I begin? I looked at "dicks-clicks" website you suggested but I don't understand how I'll know the number equivalent to a reference - i.e. olNs.GetDefaultFolder(9) - in the sample code, the 9 refers to the calendar. How do I know the other numbers? Thanks so much Cindy -----Original Message----- Hi Not all but for this one you must use Late binding also Cindy The default references change to the Excel version you open it in. Sometimes you can select a lower version number to avoid a problem For example the Microsoft ActiveX Data Objects ? library If you use 2.5 it will run in 2000 and higher -- Regards Ron de Bruin http://www.rondebruin.nl "Cindy" wrote in message ... Ron, Does the same concept apply to all library reference files in Excel because now another problem arose with the "ActiveX Recordset" library file. Please help if you can. Thanks Cindy -----Original Message----- Hi Cindy 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 "Cindy" wrote in message ... I have an Excel template that invokes a session of Outlook, which uses the msoutl9.olb reference file. If a user has a different version of outlook (outlook 10), the reference file appears to update to msoutl10.olb and when this is received by a user that has outlook 9, a compile error displays when running the code and the "Missing reference" appears in the references. I have to uncheck and reselect outlook 9 library file to get this to run. Any ideas how I can maintain this template when various users have different versions of outlook? I thought it might work if I loaded both library files on the "administers" computer. Thanks for your help Cindy . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need to get the reference library from Small Business Financials | Excel Discussion (Misc queries) | |||
| Files and folder library | Excel Discussion (Misc queries) | |||
| Excel Object Library Reference | Excel Programming | |||
| access the solver reference library | Excel Programming | |||
| Setting up Reference Library using VBA | Excel Programming | |||
Linear Mode
