PDA

View Full Version : problem with connecting to database from a different excel file



chenchuk
2011-10-23, 11:55 PM
Hi
I try this code with some modification and it works as a charm ... (http://www.excelguru.ca/node/18)
BUT ...
if i trying put my macro in the PERSONAL.XLSB (to be available for all excel docs) then it throughs an error of

" Compile error : user defined type not defined " .
it happens immediately after going into the subroutine (in the 1st row : Dim cnt As New ADODB.Connection, _ ..... )
im not sure but i guess i need to export the db connection to all the worksheets (like the PERSONAL.XLSB does for VBA code ) am i right ?

really get confused from that

Thanks anyway, and great example - well explained ! :juggle:

maninweb
2011-10-24, 01:00 PM
Hi chenchuk...

have you set a reference to the ADO Libraries?

VBA Editor -> Menu 'Tools' -> References, then check 'Microsoft ActiveX Data Objects Library'.
Then, the compiler should find the objects.

Regards :-)

chenchuk
2011-10-24, 02:22 PM
Hi
it works !!!
Thanks 4 all ... :clap2: