you dont import a csv file
you open it as a new workbook.

so: no go (but you can copy the data
from the newly opened workbook to the location your want
in an existing workbook.

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


ExcelMonkey wrote :

If you import data from a CSV or text file, is it possible to tell
which cell is the target import cell in VBA. That is, when I set up
the import, I assign A1 on Sheet1 as the cell. Is there any way in
VBA to tell when looping through sheets if there is a cell within the
Used Range that has been designated for a text file import? I know
you can do it with web queries.

Thanks