I took some research from google
Sub ExportRangetoFile() Dim wb As Workbook Dim saveFile As String Dim WorkRng As Range Set WorkRng = Sheets("Match").Range("K:K") Application.ScreenUpdating = False Application.DisplayAlerts = False Set wb = Application.Workbooks.Add WorkRng.Copy wb.Worksheets(1).Paste wb.SaveAs Filename:="C:\Users\xxxx\Desktop\newcurl.bat", FileFormat:= _ xlTextPrinter, CreateBackup:=False wb.Close Application.CutCopyMode = False Application.DisplayAlerts = True Application.ScreenUpdating = True End Sub
But the result appear in bat format was oversize. As each cell on that column contain 295 character long (string).
Hence, some part of the ending were shown at the bottom of the batch file, result the bat can't be run.
Any ideas or work around?
in one cell (excel)