Finding a line in a text file, offset x rows, and copy everything else in the file

I have searched the forums, and have not been able to find quite what I'm looking for.

I have a code that opens a text file, reads the whole thing in, then pastes to appropriate worksheets. However, I only want data starting after a particular row to the end of the file.

The code is:

Please Login or Register  to view this content.

I can not attach the actual spreadsheet, as it's proprietary, but I have attached a text file that contains the data. Again, the code works to bring in the entire file, but I only want the data starting 3 rows after the row containing "Measur.;from;to..." (i.e. the row starting with "1;") However, I can't base it on the "1;" as that may not exist in the file, but the "Measur.;from;to..." will always be there.

Thanks

J

You are using the QueryTables method that you will have to replace with methods to read the text file and do the necessary filtering and parsing. Are you familiar with that or do you need so help?

Not a problem. I'll fix you up. Can you tell me what is in the cells A1:G1 in the Averages sheet?

try this out

Please Login or Register  to view this content.

That worked, mostly.

First, the values came in as text, not number. Second, in sheets R2-R13, the data below still remained (i.e. the text from the import did not get removed). However, looking over the code, the following should have been 1 to 13. After changing that, all the worksheets were good (except the text not number thing).

Please Login or Register  to view this content.

Where would I put a line to convert text to number?

Thanks, you rock, by the way.

J

Oops, I forgot to change the 1 to a 13. I made the change while testing. Below is the changed code and the fix for the string rather than number problem. I am not sure why Excel didn't make the change itself. It is usually more clever than that.

Please Login or Register  to view this content.