I see you solved the problem. In any case, VBA projects also need a reference to the ADO type library. You can do this in the VB editor under macros and select Tools->References.

>One problem with ADO - I can't seem to get it working. I've tried creating ADODB.Connection but get a message that an ActiveX cannot create an object. If I Dim oCon As ADODB.Connection I get message User Type Def not allowed.
>
>I forgot to bring my VBA/Excel book with me and I'm not back until this evening. Fortunately, I've fixed the original piece of software in VFP and the client is aware that I'm not too hot on Excel programming.
>
>If you could give me a quick push in the right direction, I can take it from there.
>
>Tia,
>
>>
>>Convert this code to ADO which should work just fine in Excel. The alternative is to create a VFP COM Server that would do the processing.