导入TXT文件，

eq800

Sub 宏4()
Dim fid
fid = Application.GetOpenFilename("txt文件,*.txt")
    Application.CutCopyMode = False
    Range("$A$1") = fid
    With ActiveSheet.QueryTables.Add(Connection:="TEXT;D:\Documents\H7 12V\20240511\_31_20240511085819211.txt", Destination:=Range("$A$1"))
  ' With ActiveSheet.QueryTables.Add(Connection:="TEXT;)& fid &(", Destination:=Range("$A$1"))
        '.CommandType = 0
        '.Name = "_31_20240511085819211"
        .FieldNames = True
        .RowNumbers = False
        .FillAdjacentFormulas = False
        .PreserveFormatting = True
        .RefreshOnFileOpen = False
        .RefreshStyle = xlInsertDeleteCells
        .SavePassword = False
        .SaveDa
ta = True
        .AdjustColumnWidth = True
        .RefreshPeriod = 0
        .TextFilePromptOnRefresh = False
        .TextFilePlatform = 65001
        .TextFileStartRow = 1
        .TextFileParseType = xlDelimited
        .TextFileTextQualifier = xlTextQualifierDoubleQuote
        .TextFileConsecutiveDelimiter = False
        .TextFileTabDelimiter = True
        .TextFileSemicolonDelimiter = False
        .TextFileCommaDelimiter = False
        .TextFileSpaceDelimiter = False
        .TextFileColumnDataTypes = Array(1)
        .TextFileTrailingMinusNumbers = True
        .Refresh BackgroundQuery:=False
    End With
End Sub
--------------------------------------------------------------
为什么用红色部分的代码运行不了，帮忙修改一下

半百

是不是这样？