Any way to get around the 240-character line limit on text output?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
http://support.microsoft.com/default.aspx?scid=kb;en-us;131554

--
Jim Rech
Excel MVP
| 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.
 
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.
 
Back
Top