Opens Text File Opens New Book Online Excel and Excel Macro (VBA) Courses Copy Macro 'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php Sub Dateiimport() Quelle = Application.GetOpenFilename("TXT-Dateien , *.TXT") Workbooks.OpenText Filename:=Quelle, Origin:=xlWindows, StartRow:=1, DataType:=xlDelimited, TextQualifier:= _ xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, Semicolon _ :=False, Comma:=False, Space:=False, Other:=False, FieldInfo _ :=Array(1, 1) End Sub Report problem with this macro This macro does not work. There's an error in the code. Other You can write your comments about the error in the box below. Report error ALL MACROS Youtube Channel The following macros may be useful for you. Similar Results NoMacro Name 1 opens text file opens new book 2 excel operators hk 3 if the file looks in the directory, opens it or gives a message 4 Select txt file to write to new excel sheet 5 opens and copies the selected word document 6 new book opens 7 if the file looks open or not opens 8 a lot of dialog windows 9 List the names of Excel files in a folder then give them a link 10 customization of toolbars remains in the file menu 11 Add menu to file edit bar delete 12 ping the address in the cell 13 Search for a word in 30 excel files 14 find and open excel files in file path 15 a worksheet and create a hyperlink from a folder 16 send alert e-mail from microsoft outlook 17 dialog box without userform 18 Can the characters typed in the inputbox appear as "*****" (password or password characters)? 19 backups and saves the workbook (to the current directory) --- per-author 20 prints the path and name of the file to the cell