Thanks Bob,

Just answered my own question, by replacing all instances of Outlook.Application with the late bind, it removed the reference.

Will adding the Office11 version of the Outlook Library to a new directory (..\Office11\MSOUTL.olb) cause any conflicts with the Version 10 file?

It's just as a temporary measure as I go through all of the code and update it.

Thanks again,

Paul.

"Bob Phillips" wrote:

Paul,

Try using late binding.

Instead of a declaration like

Dim olApp as Outlook.Application

use

Dim olApp As Object

all other Outlook objects should be defined as Objects as well

and instantiate it like this

Set olApp = CreateObject("Outlook.Application")

rather than

Set olApp = New Outlook.Application

You will need to use values rather than Outlook constants as well.

There is a web page describing this at
xldynamic.com/source/xld_Early_Late.html

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Paul Mac" wrote in message
...
Hi All,

I'm having a porblem with a workbook that uses the Outlook Object Library
(MSOUTL.olb). In particular, the wb has references to the Version 10 file.
Now that a new computer on the network has Version 11, it is causing a few
incompatibility issues.

In particular, when the workbook, is saved on the machine that is sporting
OL2003 it saves the references to OLB version 11. When a user on version 10
opens the file, the reference is missing, as "C:\Program Files\Microsoft
Office\Office11\MSOUTL.olb" does not exist only "..Office10\MSOUTL.olb"

I've never had this sort of problem with version changes from 2000-2, so
what is the cause.

Will copying the library onto the local machine resolve the issue or is
this not advisable.

Your advice on this one is greatly appreciated.

Paul Mac.