Dave,

is there any way to use the Print # method to wtite to a file a table
in which column spacing is not lost ?

Plain text files don't have a concept of "tables" - just tabs and
spaces etc. If you want a table then you'll have to use a more
formatted approach (different file type) or pad all of your values
with spaces (even that won't work unless the app used to view the file
uses a fixed-width font)

Tim.


"deano" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Dave,
>
> is there any way to use the Print # method to wtite to a file a
> table
> in which column spacing is not lost ?
>

You want a fixed width file (like for importing to a mainframe file?):

Saved 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/groups?threadm=015...280a%40phx.gbl

deano wrote:
>
> Dave,
>
> is there any way to use the Print # method to wtite to a file a table
> in which column spacing is not lost ?

--

Dave Peterson