Hello All,
I've just started picking on VBA and i would like to extract specific data from a .txt file (zip to .rar due to file size is big) and output it to Excel. However the data i need is in separate lines, can someone help me? I need to populate all the MSPS1/2/3/4/5/7 data into the excel as shown in the output file.
I've just started picking on VBA and i would like to extract specific data from a .txt file (zip to .rar due to file size is big) and output it to Excel. However the data i need is in separate lines, can someone help me? I need to populate all the MSPS1/2/3/4/5/7 data into the excel as shown in the output file.