Ok, so as far as you know, if I can just copy the CDO.dll file to their
computer and it works, that is ok. It is legally ok to distribute the
CDO.dll file if the user already has legal copies of Outlook and Excel on
their computer.(I know this question may be out of your area and may not
pertain to this forum)

"Jim Thomlinson" wrote:

You might be able to get away with just copying CDO.dll to the host computer.
That was not an option for me because of potential administrator restrictions
on the host machines in terms of installing files and how to get the files
sent to them in the first place. The code that I was using accessed the
global address list to get e-mail addresses. When the new service pack was
installed the host machine would prompt the user that a program was trying to
access the Global Address list (it thought that the program might be a virus
trying to e-mail). It was at this point that I abandoned the project.
--
HTH...

Jim Thomlinson


"Steve" wrote:

What are the other options if I want to call Outlook from Excel. I would
need to get email addresses from Outlook and things of that nature. Also, is
it ok to load CDO.dll on the users computers? It seems that is the only file
missing, and when I copied CDO.dll from my computer to another one of my
computers it seemed to work then.. Is it necessary to install from the CD.


"Jim Thomlinson" wrote:

The CDO library is part of the Outlook install. If it is not installed then
you need to get it installed (you need the office disk and the necessary
permissions to perform an install on the host computer). I did some
developement with CDO but ended up abandoning it because of just these kind
of issues. Also note that CDO operates differently on 2000 depending on what
service pack is installed (extra security prompts the user for approvals and
such).
--
HTH...

Jim Thomlinson


"Steve" wrote:

Good day.

I am designing an Excel solution that will require CDO 1.21 library. How
can I be sure each user has this installed, and if they are using Excel 2000
or less, how can I install it for them via code or an intall routine.

Thanks,