|
![](https://clubstatic.excelhome.net/image/common/ico_lz.png)
楼主 |
发表于 2024-6-14 19:16
|
显示全部楼层
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
file = "E:\\模拟追加文本数据.txt" '按需更改
Set fso = CreateObject("Scripting.FileSystemObject")
If Not fso.FileExists(filePath) Then fso.CreateTextFile file
Set ws = ThisWorkbook.ActiveSheet
arr = [wb1].CurrentRegion '范围调整为WB1:WD**
For i = 1 To UBound(arr): For j = 1 To 3
If arr(i, j) = "" Then GoTo 100
Next j, i
100
Set rng = ws.Range("wb1:wd" & i - 1)
fileNum = FreeFile
Open file For Output As fileNum
For Each cell In rng
rowData = rowData & cell.Value & vbTab
If cell.Column - 1 = rng.Columns.Count Then
Print #fileNum, rowData
rowData = ""
End If
Next cell
Close fileNum
MsgBox "表格内容已成功复制到" & file & "。", vbInformation, "操作完成"
根据实际需要,修改一下范围就不行了,能麻烦您看看吗 |
|