I want to run a macro, which will import Text (Required or All) from Many Text Files (.txt). Each Sub Folder in Directory has a Text File, which all are needed to be parsed to a common format.
On an average I generate 40 to 50 Text Files a Day and then open each one of them and copy to excel manually then processing the data manually, which is taking much of my time.
Text file has a data like
SRR_NO |SRR_STAT| GEN_STR
------------|--------|--------------------
13765.06 CLO 71
ELT_NAME:
SDDR_3_4_3_4_RIGFLT_CSOL.DOC
SRR_NO |SRR_STAT| GEN_STR
------------|--------|--------------------
12733.01 CLO 36
ELT_NAME:
SDDR_3_4_59_HSTA_POST_BRAKE.DOC
Which I process manually like this
Sn File Name ELT_NAME: SRR_NO SRR_STAT GEN_STR
1 PROJ_MAINTENANCE_O SDDR_3_4_3_4_RIGFLT_CSOL.DOC 13765.06 CLO 71
2 PROJ_MAINTENANCE_O SDDR_3_4_59_HSTA_POST_BRAKE.DOC 12733.01 CLO 36
3 PROJ2_PRIMARY_O SDDR_1_5_7_9_CSOL.DOC 98765.06 SEC 14
4 PROJ2_PRIMARY_O SDDR_8_9_09_A_T_BKE.DOC 98763.01 CLO 67
5 PROJ2C_CORE_O SDDR_8_1_4_1_FLT_CL.DOC 90765.06 VER 45
6 PROJ2C_CORE_O SDDR_6_3_23_2_TA_PT_BR.DOC 9733.01 VER 87
Is there any way to do this through macro... Need your help in automating the parsing process. Attaching sample files (text file & manually processed file) for your reference...
Please help...
Thank you
Sample_File_Processed_(Done_Manually).xls
Sample_Text_File_PROJ_MAINTENANCE_O.txt
Bookmarks