codice:
dim i As Integer, ProdoArray() As Variant
i = 0 
rs.Open "TblProdotti", conn
Do Until rs.EOF
    redim preserve ProdoArray(i) as variant
    ProdoArray(i) = CStr(rs(0))
    MsgBox ProdoArray(i)
    i = i + 1
rs.MoveNext
Loop