That is a perennial problem, why many of us just use late-binding.

--
__________________________________
HTH

Bob

"burl_h" wrote in message
...
Mike/Bob,

I narrowed the issue down to a missing libary. It appears that when
the file is saved with excel 2007 (in compatability mode) then opened
in excel 2003 it shows that the Microsoft Outlook 12.0 object libary
is missing. I changed this to object libary 11.0 and the macro runs
fine in excel 2003. After I save the file in excel 2003 then re-open
the file using excel 2007 the object libary changes back to 12.0, the
macro runs without issue.

So the problem appears to be how excel 2007 and 2003 assign the
microsoft outlook object libaries, one wants 12.0 the other wants
11.0.

How can I overcome this?

Thanks
burl_h