extract data to a txt file

[AnnickW]

Hello all

I would like a macro that creates a txt file with selected data from a table. In the example i have, there is a small table in the sheet "data" (3 columns : first name, last name, points). Some lines are copied to the sheet "copysheet". The lines for which column C is = 0 must not be copied, but must end up in a log file. This log file should look like :

These people have 0 points :
Eve
John

Now for the code. I have managed to copy rows for which column C is greater than 0. I have found how to create a txt file, but my txt file only shows the forst line, and no data at all...

Please Login or Register  to view this content.

I guess the line that's not working is the last one of the second sub.
Can someone tell me why?

[patel45]

attach please a sample xls file and desired text file

[AnnickW]

testLog.xls
Textfile20130814_203328.txt

Sorry, i'm new here...
here you are (if it worked as it should...)

[patel45]

Please Login or Register  to view this content.

[AnnickW]

Thank you very much !!!

I had to change a thing or two : a line to make sure the LR variant is based on the data sheet even if we launch the macro while on the other one, an another to come back to the datasheet before creating the txt file.
I also made a few other minor changes (sheet names, etc.) but i don't think it was necessary.

Now it works fine !!!

Please Login or Register  to view this content.

[AnnickW]

Hum, sorry i'm back with the same question, but i realised that this solution is not going to work with the original file.
In the original file, the data is not organised into a neat table. The ranges to be copied (or stored away in a text file) are scattered across about 100 columns and 2 different sheets. And those ranges don't have all the same size (always 1 row, but 2, 3 or 4 cells wide). That's why we use a second mini macro to select the right sheet, range and destination place.
Unfortunately i don't have access to this file now since i'm on holiday.
So I'm back to my original post : why can't i build up the sText string (that's going to be used in the txt file) in this mini macro?