Hello profs
I am trying to use the VBA to import some data each time I create a text file to an excel sheet and fill out some blanks so I can use them on my script.
below is an example:
I need to fill out below info in excel (Info can be found in the text file)

LAC=
BCF=
BTS=
Sector=


I need to search word LAC, BCF, BTS, Sector and get the value associated with it and import it to the excel.

thank you in advance.