Hi!

I used the "Use a closed workbook as a database (ADO)" for the project
that I'm doing but it returned an error.

I have inputted the code on one of my modules and a button will call
the procedure.

Once I click on the button it says 'User-define type not defined for
"cn As ADODB.Connection".

Can you tell how should I do this in VBA since I'm using excel? Thanks!


--
aga2957
------------------------------------------------------------------------
aga2957's Profile: http://www.excelforum.com/member.php...o&userid=25346
View this thread: http://www.excelforum.com/showthread...hreadid=571705