Thanks. Unfortunately, the code in the support documentation gives me a run
time error "Invalid procedure call or argument" when I run the macro in
Excel. Since I'm not a VB programmer, I don't really see what the problem is
either.

"Jim Rech" wrote:

http://support.microsoft.com/default...b;en-us;131554

--
Jim Rech
Excel MVP
"awp" wrote in message
...
| 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.