I need to open a CSV file in Excel 2000, find the end of the file and select
that range and copy it to spreadsheet "B" starting at A2. I am using the
following to open the file. How can I find the end of the range of a CSV
file, then copy that range to an excel sheet.

Thanks


sfile1 = Application.GetOpenFilename("Text Files (*.csv), *.txt")
If sfile1 < "" Then
Open sfile1 For Input As 1
End If