|
发表于 2016-1-8 12:27
|
显示全部楼层
本楼为最佳答案
lhj323323 发表于 2016-1-8 12:15
01600566=洪城股份#$历史赢亏69259
洪城股份是数据源表[结果]的B列的内容
Sub 导出txt()
Dim arr, title, fullpath, str1, str2, str3, i, j
arr = Sheets("结果").Range("a1").CurrentRegion
title = Array("[MARK]", "[TIP]")
fullpath = ThisWorkbook.Path & "\标记.dat"
Open fullpath For Output As #1
For j = 0 To UBound(title)
Print #1, title(j)
For i = 2 To UBound(arr)
str2 = Format(arr(i, 1), "000000=")
str1 = IIf(Left(str2, 1) = "6", "01", "00")
str3 = IIf(j, arr(i, 2) & "#$" & arr(1, 3) & arr(i, 3), "15")
Print #1, str1 & str2 & str3
Next i
Next j
Close #1
End Sub
导出TXT3.rar
(19.33 KB, 下载次数: 17)
|
|