Sub test()
With ActiveSheet.QueryTables.Add("TEXT;C:\Documents and Settings\Administrator\桌面\12\1.txt", Range("a1"))
.TextFileCommaDelimiter = True
.Refresh
End With
End Sub
Sub test()
With ActiveSheet.QueryTables.Add("TEXT;C:\Documents and Settings\Administrator\桌面\12\1.txt", Range("a1"))
.TextFileCommaDelimiter = True
.Refresh
End With
End Sub