例子:
111-554-142-211 ...
315-524-544-114 ...
351-778-454-414 ...
...列相加意思:
111+315+351 ...=777
554+524+778 ...=777
142+544+454 ...=1140
211+114+414 ...=739得出结果如下(列与列相加 得出结果):
777-1856-1140-739说明:‘省略号’表示不固定“行”“列”
111-554-142-211 ...
315-524-544-114 ...
351-778-454-414 ...
...列相加意思:
111+315+351 ...=777
554+524+778 ...=777
142+544+454 ...=1140
211+114+414 ...=739得出结果如下(列与列相加 得出结果):
777-1856-1140-739说明:‘省略号’表示不固定“行”“列”
解决方案 »
- !!帮忙做题!!!
- 请教:如何将一张表下某个字段的全部纪录值删除?
- 求一SQL语句
- ● (转贴发,统一给分)寻求在 RichTextBox 中绘制表格的最佳解决方案 ●
- 急救:polybezier画图程序错误,帮忙找错
- 创建Excel对象的原理
- 求救!如何用vba抽出word文档中的一段文字,并写入另一个文件?
- mshflex的显示问题
- 大家好,恭喜发财!怎么把ACCESS数据库中查询到的记录转换成EXCEL文件(用的是ADO查询)
- 请问如何用Image控件模拟CommandButton按钮?
- 小数位大于0.1,小于0.5的,则返回为0.5, 例如:1.4条,则返回为1.5
- 求助:组合框里自动加载ImageListCtrl控件图标的关键字
Dim strLine As String, strItem() As StringOpen App.Path & "\test.txt" For Input As #1
Do Until EOF(1)
Line Input #1, strLine
strItem = Split(strLine, "-")
If Ubound(strItem) = 3 Then
sum1 = sum1 + Val(strItem(0))
sum2 = sum2 + Val(strItem(1))
sum3 = sum3 + Val(strItem(2))
sum4 = sum4 + Val(strItem(3))
End If
Loop
Close #1Debug.Print CStr(sum1) & "-" & CStr(sum2) & "-" CStr(sum3) & "-" & CStr(sum4)
Dim sum() As Long, i As Long
Dim strLine As String, strItem() As String Open App.Path & "\test.txt" For Input As #1
Line Input #1, strLine
strItem = Split(strLine, "-")
Redim sum(Ubound(strItem)) '测试列数
for i = 0 To Ubound(sum)
sum(i) = Val(strItem(i))
Next i
Do Until EOF(1)
Line Input #1, strLine
strItem = Split(strLine, "-")
If Ubound(strItem) = Ubound(sum) Then
For i = 0 To Ubound(sum)
sum(i) = sum(i) + Val(strItem(i))
Next i
End If
Loop
Close #1
strLine = ""
for i = 0 To Ubound(sum)
strLine = strLine & IIf(i = 0, "", "-") & CStr(sum(i))
Next i
Debug.Print strLine