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...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.

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.

I copied and pasted those two procedures into a general module and then went
back to my worksheet and tried it.

It worked fine.

Maybe you did something in the copy|paste portion.

You may want to try Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

It has lots of options built in and since it comes as a workbook, there'd be
less work for you to do.

awp wrote:

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.




--

Dave Peterson