excel - VBA to get a specific string from a multiline string -
i have below string being read notepad drive. while vba reading below string, needid(abc123) store in variable. sometime i'll have below information repeated multiple times different "needid"s , need "need id" saved in array call them later. needid = abc123 name = someone, nameenter code here type = moon = dept = xyz acdi = 96633 dent = test det below code reads above file drive set ofs = ofso.opentextfile("c:\\fileid.txt") txtfileid = ofs.readallenter any idea needid please.