|
发表于 2011-6-28 23:55
|
显示全部楼层
本楼为最佳答案
写了两个供参考(一个改自录制宏)
Sub 宏1()
fn$ = Dir(ThisWorkbook.Path & "\test\?.txt")
Do While fn <> ""
Open ThisWorkbook.Path & "\test\" & fn For Input As #1
Line Input #1, s$
Close #1
i% = Len(s)
If InStr(s, " ") Then i = InStr(s, " ")
Workbooks.OpenText Filename:=ThisWorkbook.Path & "\test\" & fn, Origin:=936, StartRow:=1 _
, DataType:=xlFixedWidth, FieldInfo:=Array(Array(0, 1), Array(i, 1)), _
TrailingMinusNumbers:=True
Columns("A:A").Select
Selection.Delete Shift:=xlToLeft
ActiveWorkbook.SaveAs Filename:=ThisWorkbook.Path & "\test\a" & fn, FileFormat:=xlText, _
CreateBackup:=False
ActiveWorkbook.Save
ActiveWindow.Close 0
fn = Dir
Loop
End Sub
Sub 宏2()
fn$ = Dir(ThisWorkbook.Path & "\test\?.txt")
Do While fn <> ""
Open ThisWorkbook.Path & "\test\" & fn For Input As #1
Open ThisWorkbook.Path & "\test\b" & fn For Output As #2
Do While Not EOF(1)
Line Input #1, s$
If InStr(s, " ") Then s = Mid(s, InStr(s, " ") + 1)
Print #2, s
Loop
Close #1
Close #2
fn = Dir
Loop
End Sub |
|