Never mind, I was able to find the answer and the problem is resolved.

Jan :)

"Jan Il" wrote in message
...
Hi all! :-) Windows XP Pro, Excel 2002 XP

I have an application that was created in Excel 2000, and when I try to
add functions such Sum or Average, in a column, I am getting an error
message that says:

Can't find project library

When I click OK on this box, it open the VBA Reference box and highlights
the following with a check in the box next to:

Missing: Microsoft CDO 1.21 library

Details show it is looking for it in the C:\WINNT\system32\cdo.dll

I have 2 active drives in my computer, each with a different version of
Windows
C:\ = W2K
G:\ = WinXP Pro

I have run a repair of the Office 2002 XP to see if it might reinstall the
necessary library, however, it is still firing this error each time I try
to create specific functions in this app.

I have never had this kind of error before, and all the functions in
Access seem to be operating properly, thus, not sure what might be causing
the problem, and not sure why it is looking for a library in the wrong
drive.

I'd truly appreciate any suggestions or information on this issue to help
sort it out. :-)

Jan :)