This Microsoft article might be of assistance.How To Use ADO with Excel Data from Visual Basic or VBAsupport.microsoft.com/default.aspx