If (ActiveWorkbook.Path & "\" & Replace(ActiveWorkbook.Name, ".xls", "")) = "" Then MkDir (ActiveWorkbook.Path & "\" & Replace(ActiveWorkbook.Name, ".xls", ""))
lieshu = Range("IV1").End(xlToLeft).Column
For i = 1 To lieshu
hangshu = Range(Cells(65536, i), Cells(65536, i)).End(xlUp).Row
Open ThisWorkbook.Path & "\" & Replace(ActiveWorkbook.Name, ".xls", "") & "\" & CStr(Cells(1, i).Text) & ".txt" For Output As #1
For k = 2 To hangshu
Print #1, Cells(k, i)
Next
Close #1
Next
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/962bd40735fae6cd8bf470bc0ab30f2443a70faf?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
excel、在附件里