Hi Good people,
I need a Macro to do the following
1. Loop through a folder with multiple csv files
2. In each csv file, delete all columns except Column G
3. Delete Row 1 in Column G
4. Delete empty rows in Column G
5. Save all CSV files as text files in the same folder with the same file name.
All CSV files have the same format.