Macro works in Excel, does not work on files opened with Excel

Hello.

The macro below was created to report on data that was originally in ascii format. The macro works if I paste the text into Excel. But it doesn't work if I open the text file in Excel (even if I rename the file first). It deletes all rows instead of specified rows.

The cell arrangements are the same whether the info is pasted in excel or opened in excel.

Is this normal - or are there any changes I can make to the macro to account for it being used on a text file opened with excel?

Here is my macro, and below is some test data if anyone cares to look at it.
PS - Many thanks to those forum members that gave me hints along the way to create this.

Please Login or Register  to view this content.