VBA xsl to multiple text files!

[miss_georgina]

Hi there,

I've got 340 sets of data in excel format that I need in individual text files.

I've got a script which takes the data, currently all on one worksheet, and seperates it into 340 seperate excel files and it works. But I'd like to do the same, but save it as delimited text files instead.

I'd be really grateful for some help on this.

Many thanks,

Georgina

[Chippy]

Just guessing, but if your code saves each file using Workbook.SaveAs, try recording a macro with you doing File - Save As - Text (tab delimited) and use that instead, with edits to save to the appropriate file name.