As it happens.., you can use ADODB to handle data in Excel in a
database fashion. It treats an Excel file as a database, and a sheet
(or range) as a 'table'. The beauty of it is you do not have to have
the data source file open! See here for more info...

http://www.appspro.com/conference/Da...rogramming.zip

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion