How to export each rows from straight table to text file?

[bill_mtc]

Hi everyone!

I have this macro development, I need to export each rows from straight table to text file, depending on the remarks...

Sample data below:

ID	NAME	AMOUNT	REMARKS
1	Leroy	100007	Qualified
2	George	50008	Not Qualified
3	Bill	890027	Qualified
4	Scottie	8922	Not Qualified
5	Ringer	19800	Qualified
6	LG	67882	Qualified

If above data will be the basis, following are instructions:

1. Extract each row into text file, name the text file according to each ID
2. Extract only rows of data if REMARKS is "Qualified"
3. Expected total number of extracted textfile is 4.

Looking forward for your ideas..

Regards,

Bill

[bill_mtc · Accepted solution]

To all readers, fortunately, I was able to solve this problem. Please find attached files for your reference!

PSEUDOCODES:

1. Check if file destination is exist
2. If No, then Exit
3. If Yes, then Check if row data is Qualified to export to text file
4. If Qualified, then create each row a text file
5. If Not Qualified, then loop or continue next record