I want to save an excel file as a text file in VBA:
xlFile.SaveAs filename:=outputFile, FileFormat:=xlText
The problem is it is enclosing the double quote character in quotes in the saved file. For example, suppose the text in cell A1 is "Test." Then the saved test file will contain """Test.""" How do I get it to save as a text file without enclosing double quote characters in quotes?