Saving As. . PRN file problem broken up columns..

[db_murray]

When I "save as" a Formatted Text (space delimited) format the output
is broken up.

I have around 58 colums of data that need to be saved to a PRN file as
a dataset for a visual basic program. When I save as a Formatted Text
(space delimited), quit, then open in WordPad the data has been split
and stacked on top of each other doubbleing the amount of rows.
Because it is now out of order the data set does not work witth the
intended porgram. Is there a way to increase the # of colums that are
exported in the PRN format with Excel 2003?

 

[Dave O]

I learned recently that WordPad will wrap text if it is configured to
do so. Is yours set to wrap?

If not, I think the trick is going to be a matter of choosing one
output format or another, whether it's PRN or TXT or CSV or what, that
is compliant with the VB program. This will require some
experimentation with the different formats. If you wind up using .TXT,
for instance, you can either revise the VB code to look for a TXT file
or rename the file from myfile.TXT to myfile.PRN.

If it comes down to it, you could write a VBA routine to write the
values to a file.