With ws.QueryTables.Add(Connection:="TEXT;" & FilePath, Destination:=ws.Range("A1")) .TextFileParseType = xlDelimited .TextFileTabDelimiter = True ' Change to False if using comma .TextFileCommaDelimiter = False .TextFileSemicolonDelimiter = True ' Common in ASC exports .Refresh BackgroundQuery:=False End With MsgBox "ASC timetable imported successfully into Excel 2021"
The most efficient way to get your data into Excel 2021 is through the dedicated export menu. asc timetables to excel 2021