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 :-)
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 !![]()
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 :-)
Hi
it works !!!
Thanks 4 all ...![]()
Bookmarks