Hello All,
Appreciate help this forum and contributor provides.
I have existing macro (below) which combines (50+) multiple text file delimited via "|" from given folder and saves as as excel table. I want to add text file name to given record field in table so i know where I pulled this record from and which file it belongs to. Can this be done in this macro? I have to do this every day so this would help in validation.
Folder has multiple .txt file like below
I_CNNSR6_09112012.txt
E_CBSSR6_09122012.txt
I want to add file name as column field against the record from that file let say E_CBSSR6_09122012.txt file has following records (or multiple) pulled in table
Location|Product1 |38080090|7500|KGS|7510937.5
Location|Product2 |38081090| 500|KGS|751937.5
I want get this way in my table columns
Col A Col B Col C Col D Col E Col F Col G
Location Product1 38080090 7500 KGS 7510937.5 E_CBSSR6_09122012
Location Product2 38081090 500 KGS 751937.5 E_CBSSR6_09122012
Thanks
NKRA
Credit to following for following macro site http://www.rondebruin.nl/csv.htm
Macro
Bookmarks