https://community.blueprism.com/t5/Product-Forum/Save-xls-file-as-a-txt-Tab-delimited-format/m-p/44637#M1053 this worked for me: Imports Microsoft.Office.Interop.Excel Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Dim excelApplication As New Application Dim excelWrkBook As Workbook Try excelApplication.DisplayAlerts = False excelWrkBook = excelApplication.Workbooks.Open(""c:\TestFolder\MAIN_Total.xlsx"") excelWrkBook.SaveAs(Filename:=""c:\TestFolder\MAIN_Total.txt"", FileFormat:=Microsoft.Office.Interop.Excel.XlFileFormat.xlTextMSDOS) excelWrkBook.Close() excelApplication.DisplayAlerts = False excelApplication.Quit() Catch ex As Exception Throw ex Thu, 02 Nov 2017 21:37:00 GMT RickMartin 2017-11-02T21:37:00Z https://community.blueprism.com/t5/Product-Forum/Save-xls-file-as-a-txt-Tab-delimited-format/m-p/44635#M1051 Hello, I have one .xls file and i want save that Excelsheet as a .txt ( tab delimited ) format. How to do that ? Quick help is appreciated. Thanks Thu, 02 Nov 2017 16:21:00 GMT https://community.blueprism.com/t5/Product-Forum/Save-xls-file-as-a-txt-Tab-delimited-format/m-p/44635#M1051 HarishPasham 2017-11-02T16:21:00Z https://community.blueprism.com/t5/Product-Forum/Save-xls-file-as-a-txt-Tab-delimited-format/m-p/44636#M1052 this worked for me: Imports Microsoft.Office.Interop.Excel Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Dim excelApplication As New Application Dim excelWrkBook As Workbook Try excelApplication.DisplayAlerts = False excelWrkBook = excelApplication.Workbooks.Open(""c:\TestFolder\MAIN_Total.xlsx"") excelWrkBook.SaveAs(Filename:=""c:\TestFolder\MAIN_Total.txt"", FileFormat:=Microsoft.Office.Interop.Excel.XlFileFormat.xlTextMSDOS) excelWrkBook.Close() excelApplication.DisplayAlerts = False excelApplication.Quit() Catch ex As Exception Throw ex Thu, 02 Nov 2017 21:37:00 GMT https://community.blueprism.com/t5/Product-Forum/Save-xls-file-as-a-txt-Tab-delimited-format/m-p/44636#M1052 RickMartin 2017-11-02T21:37:00Z https://community.blueprism.com/t5/Product-Forum/Save-xls-file-as-a-txt-Tab-delimited-format/m-p/44637#M1053 this worked for me: Imports Microsoft.Office.Interop.Excel Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Dim excelApplication As New Application Dim excelWrkBook As Workbook Try excelApplication.DisplayAlerts = False excelWrkBook = excelApplication.Workbooks.Open(""c:\TestFolder\MAIN_Total.xlsx"") excelWrkBook.SaveAs(Filename:=""c:\TestFolder\MAIN_Total.txt"", FileFormat:=Microsoft.Office.Interop.Excel.XlFileFormat.xlTextMSDOS) excelWrkBook.Close() excelApplication.DisplayAlerts = False excelApplication.Quit() Catch ex As Exception Throw ex Thu, 02 Nov 2017 21:37:00 GMT https://community.blueprism.com/t5/Product-Forum/Save-xls-file-as-a-txt-Tab-delimited-format/m-p/44637#M1053 RickMartin 2017-11-02T21:37:00Z