|
楼主 |
发表于 2016-6-6 19:58
|
显示全部楼层
爱疯 发表于 2016-6-6 17:05
Sub WriteText1()
Dim A, i, c
c = Cells(1, "A").Column
老师你好!非常感谢你,你这句中有些不明白,你可以帮我解答下吗?
Sub WriteText1()
Dim A, i, c
c = Cells(1, "A").Column ‘下句的A相当于是一个单元格区域,如果我要导出A列和B列,该怎么写呢?
A = Range("a1:j" & Range("a65536").End(xlUp).Row)
Open "d:\1.txt" For Output As #1
For i = 1 To UBound(A) '怎么导出二维数组呢?
Print #1, Format(A(i, c), "00") '我试了如果是1的话,则导出是01。我想导出仍是1的话,该定义哪种呢?
Next i
Close #1
End Sub
|
|