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