|
Sub 打开() Dim Filt As String Dim Title As String Dim FileName As Variant Filt = "Text Files (*.txt),*.txt," Title = "请选择文件" FileName = Application.GetOpenFilename(FileFilter:=Filt, Title:=Title) If FileName = False Then MsgBox "未选择任何文件" Exit Sub End If Workbooks.OpenText FileName:= _ FileName, Origin:= _ 936, DataType:=xlDelimited, Space:=True, FieldInfo:=Array(Array(1, 2), Array(2, 2), Array _ (3, 2), Array(4, 2), Array(5, 2), Array(6, 2), Array(7, 2), Array(8, 2), Array(9, 2), Array( _ 10, 2), Array(11, 2), Array(12, 2)), TrailingMinusNumbers:=True End Sub |
|