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: