Hello,

I have coded a macro that imports text file data and parses it into a worksheet. I have the macro count each line as data is imported and display the number imported on the status bar in the lower left corner of Excel. Right now, I have it set to say "### of records imported."

I would like it to say "### of ### records imported" and then build a progress bar based upon this data. I do not know how to analyze a text file to obtain the number of lines it contains. Some of the text files I would import could be millions of lines, so it needs to be done quickly. Importing the text file alone can take several minutes.

It is a minor detail, but if anyone knows how to do this without much trouble, please let me know.

Thank you,

NicB.