|
将execl的sheet1中的列A,C,E导出,并生成txt文件
每个单元格数据间“,”隔开
每行最后一个数据“;”结束
如
表中数据
A C E
1 3 4
2 5 7
4 9 6
则
txt数据
1,3,4;
2,5,7;
4,9,6;
- Sub ACEToTXT()
- Dim arr
- Dim fileNO
- Dim strFile$
- Dim i As Long
- On Error GoTo ErrorHandler:
- strFile = ThisWorkbook.Path & Application.PathSeparator & Format(Now, "yyyymmddhhmm") & ".txt"
- fileNO = FreeFile
- Open strFile For Output Access Write As #fileNO
- arr = ActiveSheet.UsedRange.Columns("a:e").Value
- For i = 1 To UBound(arr)
- Print #fileNO, IIf(IsNumeric(arr(i, 1)), Format(arr(i, 1), "000000"), arr(i, 1)) & "," & IIf(IsNumeric(arr(i, 3)), Format(arr(i, 3), "000000"), arr(i, 3)) & "," & IIf(IsNumeric(arr(i, 5)), Format(arr(i, 5), "000000"), arr(i, 5))
- Next
- Close #fileNO
- MsgBox "文件导出到 " & strFile
- Exit Sub
-
- ErrorHandler:
- MsgBox Err.Number & vbCrLf & _
- Err.Description
- Err.Clear
- Close #fileNO
- End Sub
复制代码
|
|