Row Count of Imported Notepad File

[music_al]

Hi

I have a sub routine that prompts the user to open a file and the user then selects a NOTEPAD file. The sub routine then cleanses the file and formats certain cells.

I then want to return the number of rows in the file but the code I'm using only returns 1 when there are 230 rows in the file...

Batch_Row_Count = ActiveSheet.UsedRange.Rows.Count


Is this because it is not an Excel file even though I have opened it in Excel ?

Thank you in advance.

Al

 

[music_al]

If you were to put a button in another spreadsheet and call this code from that button, you might see what's happening.

 

[steve the fish]

It works fine for me opening a text file. It becomes the activeworkbook regardless how the code is run. I cant replicate what you say is happening.