读写文档,计算
一个文档中有3456
8764
3374
分别读取每行四个数,并赋予某个数组。
2022-11-15 21:36

2022-11-16 10:16
2022-11-16 15:56
程序代码:Sub Test()
Dim s() As String, t(1 To 4) As Long, i&, j&, sum&
Open "d:\1.txt" For Input As #1
s = Split(StrConv(InputB(LOF(1), 1), vbUnicode), vbCrLf)
Close #1
For i = 0 To UBound(s)
sum = 0
For j = 1 To 4
t(j) = Val(Mid(s(i), j, 1))
sum = sum + t(j)
Next
s(i) = s(i) & "-->" & sum
Next
MsgBox Join(s, vbCrLf)
End Sub
2022-11-16 21:18