I'm trying to save an Excel file into a fixed-length file for import into a
mainframe and the biggest problem (as pointed out in another post on this
board) is that there is a limit of 240 characters per line. This causes the
rest of each line to be placed at the end of the file. My record layout
length is around 300 and we're talking about 50,000 records.

How can I get around the 240 character limit to save this file in an
acceptable format? Otherwise it will take hours of work to get the file in
the proper format.