|
本帖最后由 lijian8003 于 2015-10-24 20:39 编辑
下列代码将excel各列数据导入txt文本,速度慢。能否提速?
Sub 导出()
Dim x
For x = 1 To 702
Call 导出1(x)
Next x
End Sub
Sub 导出1(x)
Dim i&, j%, k, s, arr
arr = Sheets("参数1").UsedRange
Open "d:\分解\参数1\" & Format(x, "0000") & ".txt" For Output As #1
For i = 1 To 1470
s = ""
For j = x To x '假设数据区域有多列
s = s & vbTab & arr(i, j)
Next
Print #1, Mid(s, 2)
Next
Close #1
End Sub
小改一下, - Sub 导出()
- Call 导出1(1, 5) '导出第1列--第5列
- End Sub
- Sub 导出1(x1, x2)
- Dim i&, j%, k, s, arr
- arr = [a1].CurrentRegion
- Open ThisWorkbook.Path & "" & Format(x1, "0000") & "-" & Format(x2, "0000") & ".txt" For Output As #1
- For i = 1 To UBound(arr)
- s = ""
- For j = x1 To x2 '假设数据区域有多列
- s = s & vbTab & arr(i, j)
- Next
- Print #1, Mid(s, 2)
- Next
- Close #1
- End Sub
复制代码
|
|