Question: how to convert excel to text file in macro?
Answer: Launch Excel and click the "Developer" tab above the ribbon menu; then click the "Visual Basic" button.
Type "Sub ConvertToText()" (without quotation marks) into the code pane.
Type the following code under the "Sub" heading: