When I type

Dim cnn As ADODB.Connection

to connect to another excel from within excel I get the error

user-defined type not defined

I would appreciate if someone could help me on this.

Thanks

You need to set a reference to "Microsfot ActiveX Data Objects" (ADO for short) first.

In the VBE select Tools -> References... From the dialog box that pops up, scrolll down until you find an entry that reads something like Microsfot ActiveX Data Objects 2.7 Library (the number might be different - pick the highest number you can see). Check the tick box next to this entry and then click ok. You should be good to go now.

Maccas

Thank you1