Export worksheets to delimited text files (with ability to exclude worksheets and areas)

[trilliansounds]

Hi,

Ive pieced together two scripts from other threads to save all the rows in each worksheet (excluding one named worksheet (Input) and the 1st row in each worksheet) as pipe delimited text, with the file name corresponding to the name of the worksheet (eg Sheet 1.txt) but... I'm getting text files with nothing in them at the end. Any ideas what could be going wrong here?

Please Login or Register  to view this content.

Sources:
http://www.cpearson.com/excel/ImpText.aspx
AND
https://sites.google.com/a/madrocket...-sheets-to-txt

[trilliansounds]

I've been trying to solve this myself - another solution uses a technique of opening a pre-defined txt file, inserting the data from a worksheet then closing the file.

http://www.mcgimpsey.com/excel/textfiles.html

But I can't engineer it to do what I want. The code from mcgimpsey doesn't cycle through the worksheets in the book nor does it allow you to exclude a worksheet from the export and the filenames must be derived from the name of the active worksheet, they can't be pre-defined.