Can anyone help me convert this to autoit natively? With ActiveSheet.QueryTables.Add(Connection:= _ "TEXT;" & CStr(TxtName), Destination:=Range("$A$1")) .Name = "Data" .FieldNames = True .RowNumbers = False .FillAdjacentFormulas = False .PreserveFormatting = True .RefreshOnFileOpen = False .RefreshStyle = xlInsertDeleteCells .SavePassword = False .SaveData = True .AdjustColumnWidth = True .RefreshPeriod = 0 .TextFilePromptOnRefresh = False .TextFilePlatform = 43