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:
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: