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