It’s a fairly common requirement to need a bit of VBA code to write Excel data to a text file. There are several methods you can use to do this, but here’s an example which I like to use, as it offers good control over the range of data, the structure and format of the text output and – unusually – control over the text encoding / character set:

http://excel.solutions/2014/04/using...-to-text-file/