Exporting one column to text file

Hello everyone.

I've created a spreadsheet to help me create a text file which I can use to inport values into another device. Using CONCATENATE etc I end up with a range of cells (1 column / Many rows) that I can then MANUALLY highlight, choose copy, open the text file, paste in the contents and then save it. This works fine but as you can imagine I'd like to automate the proceedure by having excel create and save the text file for me.

From what I've seen on these forums most people are wanting CSV type files but not me. I've already got the cell contents pieced together it just needs writing to a text file, no delimiters, no quote marks, just exactly what's in the one cell on one line, it's just one column remember (H2:H1456).

I'm not bothered about appending data either, a hard coded overwrite of the text file is fine by me.

The actual file type I ultimately need is an .abk file, but like I say this is just a basic text file that's been renamed. Could Excel create this or must it have the .txt file extension?

If anyone could help with the code I would be most grateful as most of my VBA is learn from re-engineering macros, but I can't seem to do this one myself.

Many thanks

Brelin

Thanks for the responce.

Yes, I'm getting a text file out but it does not use a new line in the text file for each row, can it be changed to do a new line per row?

Thanks

Brelin

That's working spot on now many thanks !

Out of curiosity I'd like to ask one more question if I may. Some of the rows within the source spreadsheet column do not contain any data and of course are still treated as new lines in the text file. Is it possible to have it skip writing a line to file if it contains a particular character or word? I'm thinking that if I tweak my forumulas so that the word "Skip" or something appears in cells then that row should be skipped. The thing is not all blank lines can be missed hence my suggestion of using a 'skip' word. Don't get me wrong the other device can pick up the data no matter how many blank lines it's got in it but cosmetically speaking the text file is easier to review with unrequired lines removed.

Thanks again Dom.

Brelin

Alternative way to clean data would:
- save worksheet as csv file
– download TextMaster from www.textmaster.ca
– run SQL like queries (delete and / or update) using any field or group of fields in where clause to remove unwanted lines.
TextMaster support is very good and they can help you with details.