一个循环的问题
我想在出来的数据最前头或最后加一行数据,如
3条记录 (加的一行)
210125
210245
145625
但写到代码中出来就成了,每循环一次就要加一行
1条
210125
2条
210245
3条
145625
代码如下,Print #4这两段就是要写进去的,如何改才能得到我要的格式:
Open StrSrcfile For Input As #1
Do Until EOF(1)
j = 0
Line Input #1, strline
strBank = MidX(strline, 12, 10)
If MidX(strBank, 4, 3) = "ICB" Then
If blexist = False Then
blexist = True
Open "2ICBDC" & CStr(Year(Date) * 10000 + Month(Date) * 100 + Day(Date)) & ".TXT" For Output As #4
strfileexist(i) = "2ICBDC" & CStr(Year(Date) * 10000 + Month(Date) * 100 + Day(Date)) & ".TXT"
i = i + 1
Else
Open "2ICBDC" & CStr(Year(Date) * 10000 + Month(Date) * 100 + Day(Date)) & ".TXT" For Append As #4
End If
Casecount = Casecount + 1
Caseamount = Caseamount + Val(strAmount)
Print #4, Casecount & Format(Caseamount, "####0.00")
Print #4, strAmount & "|||"
Close #4
End If
Loop
Close #1