title: How can I avoid Line feeder in text file when I write the content from excel sheet?
body: <p>My Piece of VBA code for writing content from excel sheet to text file is as below.</p>
  
  <pre><code>ActiveWorkbook.Sheets("Sheet1").Activate
  With ActiveSheet
      .Range(.Cells(1, 1), .Cells.SpecialCells(xlCellTypeLastCell)).Select
  End With
  Dim strPath As String
  Dim FSO As Object
  Dim oFile As Object
  Set oFile = Nothing
  Dim c As Range
  Dim linefeed_remover
  strPath = "path"
  Set FSO = CreateObject("Scripting.FileSystemObject")
  Set oFile = FSO.CreateTextFile(strPath &amp; filesname)
  For Each c In Selection
      oFile.Write Application.WorksheetFunction.Clean(c.Value) &amp; vbLf
  Next c
  oFile.Close
  strNameOld = strName &amp; "_Old"
  'MsgBox "File Created"
  'conn2.Close
  </code></pre>
  
  <p>can anyone help me in solving this?</p>