problem with connecting to database from a different excel file

chenchuk

New member
Joined
Oct 23, 2011
Messages
2
Reaction score
0
Points
0
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:
 
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 :)
 
connection to MySQL

Hi
it works !!!
Thanks 4 all ... :clap2:
 
Back
Top