From: davidcm1@optushome.com.au   
      
   No worries   
   Just declare excel as an object   
   then use   
   object.document.open(name)   
   G = object.sheet1.cells(x,y).value   
   G variable will change as x row y column changes   
   See OLE in HELP   
   Fast reply on the way out, just let you know thats its possible and in the   
   documentation.   
   My client has thousands of xls and I open any number of xls and reference   
   any thing dynamically.   
   David Merry   
   davidcm1@optushome.com.au   
      
   "Robert Dyke"  wrote in message   
   news:woWdnV_pT4wtCwvZnZ2dnUVZ_r2dnZ2d@bresnan.com...   
   > Hey ... I've got about 500 Excel files with data stored in them in tabular   
   > format ... (my coworker used excel as a database).   
   >   
   > I want to write a vb6 program that will open up these files and get the   
   > info   
   > from each row, and store it in an MS Access database, or perhaps a   
   > comma-delimited file.   
   >   
   > How can I get into an excel file with VB6?  I have VB6 enterprise, and   
   > I've   
   > installed the "excel" data access components.   
   >   
   > Thanks in advance   
   >   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)