I fixed that error.. it was looking for xwb.Activesheet.Cells(iRow,iCol)
Now all I need is to figure out which portion of which of these variables
contains the numbers for the actual last column and row that has a value.
Thanks Steve

....and thanks for trying Tom, but unless I'm really missing something, ADO
doesn't work. I have text in the first few rows in column A, and further
down column A has numbers. ADO does not read in the numbers. It sounds
like the Excel object thing is what I was looking for.

"Eric" wrote in message
...
I started down the path you're talking about here. I managed to open the
excel file and could see it in the debug watch, but couldn't figure out
how
to read the cells. I tried this code you put in here, and got runtime
error
438 "Object does not support this property of method" on the line: vTmp =
xwb.Cells(iRow.iCol)
....