[VBA ] 請問如何擷取我需要data的下一欄字元..
我預計要用
Result_data = ActiveWorkbook.Path & "\result.txt"
Open Result_data For Input As #1
Do While Not EOF(1)
Line Input #1, ReadLine
去讀出我要的內容
例如:我的內容如下
EEEE
ZZZZ
AAAA
BBBB 33333
CCCC
FFFF
GGGGG
我想要卡兩個條件...
當我符合AAAA條件之後..在去比對下一欄是否是BBBB
如果是的話...就把BBBB後面的3333 給匯出來
如果是單一行的...
我就直接用
if mid(ReadLine,0,4) = "AAAA" then ......
但是如果是有要考慮AAAA和他下一欄的話...我該怎麼寫呢????
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 114.40.78.52
→
12/31 02:35, , 1F
12/31 02:35, 1F
→
12/31 13:35, , 2F
12/31 13:35, 2F
→
12/31 13:36, , 3F
12/31 13:36, 3F
→
12/31 13:53, , 4F
12/31 13:53, 4F
→
12/31 14:57, , 5F
12/31 14:57, 5F
→
12/31 14:57, , 6F
12/31 14:57, 6F
→
12/31 14:58, , 7F
12/31 14:58, 7F
→
12/31 20:30, , 8F
12/31 20:30, 8F