View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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