Yo can open a text file in a macro and read one line at a time into the
worksheet. You can also read through the entire file to find the number of
lines.. then return to the beginning of the file and read the file into the
worksheet. Opentext method is just an easy was of reading a text file but
doesn't have all the options you require. there are a number of methods that
can be used such as OpenTextfile Method, Open file, and Getfile are a few
methods.

"Faraz A. Qureshi" wrote:

Upon importing data from a txt file can the user be intimated of the number
of rows/records existing in such a file so as o determine the time and # of
rows available in the sheet?
--
Best Regards,

Faraz