Library Reference files

[Cindy]

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

 

[Ron de Bruin]

Hi Cindy

Use Late Binding

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

 

[Cindy]

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

 

[Ron de Bruin]

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

 

[Cindy]

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
picture:

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" <[email protected]> wrote in

message news:[email protected]...