how to export large files in prn format

[Tom]

Have an excel spreadsheet that has a record length of over a 1000+
characters. Export it as a 'prn' extension, but when I look at the prn file
I find that it has been broken up into 3 segments. This is not a problem
with wordwrap as that is turned off. I have even verified in multiple
editors that this file has been segmented out by Excel. Problem is I don't
know why it is or how to change Excel it so it will export the entire record
intact.

 

[Dave Peterson]

When xl creates a .prn file, it's limited to 240 characters.

Maybe you could use a macro that writes your data:

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

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

======
Earl's may be sufficient right out of the box. He supports lots of options.

==============
If you need fixed width files...

Save from a previous post:

There's a limit of 240 characters per line when you save as .prn files.

You have a few choices (try against a copy of your worksheet):

I'd either concatenate the cell values into another column:

=LEFT(A1&REPT(" ",5),5) & LEFT(B1&REPT(" ",4),4) & TEXT(C1,"000,000.00")

(You'll have to modify it to match what you want.)

Then I'd copy and paste to notepad and save from there. Once I figured out that
ugly formula, I kept it and just unhide that column when I wanted to export the
data.

If that doesn't work for you, maybe you could do it with a macro.

Here's a link that provides a macro:
http://google.com/[email protected]

=========

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm