How to sort csv file first before extracting rows of data from it

I have this code that works fine before, now the source csv file data is arranged in descending order, how to add code to sort the csv file to ascending order first, before extracting the last no. rows of data,

some csv are having header in row 1 (Date Time ......) and some don't have header, how to ignore/delete the header before applying the codes.

How to modify the following code, thanks

Please Login or Register  to view this content.

Start at the bottom and fill upwards.

Please Login or Register  to view this content.

thanks for help,

when i run the code all sheets return empty. I want to get the data of last/newest 1000 rows. not starting from 1000 row


so i think the code would be to get the first 1000 rows now, as they are now in descending order, and then sort them to ascending order, how is the code to apply

Unfortunately, since I don't know what the date format is, or where it might be in the line, I can't test for its existence. Also, I can't code for the sort because we don't have a sample file, since it seems that there might be a different number of columns in each row after the SPLIT operation.
You could read the first 1000 lines with only one Open/read code such as:

Please Login or Register  to view this content.