- 帖子
- 155
- 主題
- 1
- 精華
- 0
- 積分
- 200
- 點名
- 4
- 作業系統
- windwos 7
- 軟體版本
- 64bit
- 閱讀權限
- 20
- 註冊時間
- 2017-5-29
- 最後登錄
- 2026-10-25
|
試試
Sub test()
Dim f As Integer, temp(1 To 3)
f = FreeFile
Open "c:\test.txt" For Output As #f
For i = 1 To 5
For j = 1 To 3
temp(j) = Chr(34) & Cells(i, j) & Chr(34)
Next j
Print #f, Join(temp, ",")
Next i
Close #f
End Sub |
|