So i have created a workbook with multiple sheets to input users information into a line of code on the last worksheet. Then i can save that last worksheet as formatted text (space delimited), or a .prn file, then creating it into a batch file.

It works great with basic info, making a short line of code. But once i get all of the info in, the lines of code exceed the .prn limitation. Thus it breaks up the lines of code in the result. The other text files seem to put extra characters in, which can't really happen.

The questions that this boils down to is; Is there a different way that i can export the information out of excel in a basic text file?