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.
Comments
Post a Comment