>Thanks for the imput. I think the only way to do this is use the IMPORT command and rewrite my excel workbook to have a separate data sheet to import from.
>
>Thanks again to all
Chuck,
You could just get the portion from Excel to a tab delimited string and parse it the way you like :
oExcel = createobject('Excel.Application')
With oExcel
.Workbooks.Open(getFile('xls'))
.ActiveWorkbook.ActiveSheet.Range("A2:C30").Copy
lcData = _cliptext
_Cliptext = ""
.quit
Endwith
lcData is a representation of tab delimited file as string.
Cetin