Later edit: I manage to write this macro after digging this forum, found some code and learn how to modify it to make what I need. Thanks guys!
I have an .xls file with lots of columns (A to DM) and rows (9000+) that I can open in OpenOffice.
I'm looking for a macro to run in OpenOffice in order to export some data from this file in 8 separate tab delimited .txt files, like this:
In txt file T.txt should be exported all rows (except row 1) with greater than 0 values in column T and all the data (tab delimited) from this colums: columns from B to S, column T, column AB.
In txt file U.txt should be exported all rows (except row 1) with greater than 0 values in column U and all the data (tab delimited) from this colums: columns from B to S, column U, column AB.
In txt file V.txt should be exported all rows (except row 1) with greater than 0 values in column V and all the data (tab delimited) from this colums: columns from B to S, column V, column AB.
In txt file W.txt should be exported all rows (except row 1) with greater than 0 values in column W and all the data (tab delimited) from this colums: columns from B to S, column W, column AB.
In txt file X.txt should be exported all rows (except row 1) with greater than 0 values in column X and all the data (tab delimited) from this colums: columns from B to S, column X, column AB.
In txt file Y.txt should be exported all rows (except row 1) with greater than 0 values in column Y and all the data (tab delimited) from this colums: columns from B to S, column Y, column AB.
In txt file Z.txt should be exported all rows (except row 1) with greater than 0 values in column Z and all the data (tab delimited) from this colums: columns from B to S, column Z, column AB.
In txt file AA.txt should be exported all rows (except row 1) with greater than 0 values in column AA and all the data (tab delimited) from this colums: columns from B to S, column AA, column AB.
Please anyone can help? Many thanks in advance!
PS: I dont use Excel, the macro should be able to run in OpenOffice Calc 4.1.4 on a Windows 10 machine. Thanks!