saving excel table as text file

[phillip harrison]

Hi there

I really hope someone can help me with this please. I have, in excel,
x columns and y rows containing numerical data. What I need to do is
first create and then save the table into a text file, but retain the
original layout of the data.

Any ideas would be greatly appreciated

Thanks


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Dave Peterson]

I'm not sure what retain the original format means, but if the data is the whole
worksheet, couldn't you just save a copy of that file as .prn or .csv?

If the data is less than the whole worksheet, you could copy it to a new
worksheet and save it from there?

or:

You may want to try Earl Kiosterud's Text Write program:

It's available at Tushar Mehta's site:
http://www.tushar-mehta.com/
Look for Text Write in the left hand frame.

Or maybe write your own:
Chip Pearson has some nice get-started code at:
http://www.cpearson.com/excel/imptext.htm

 

[Michael Bednarek]

[snip]

To be clearer in what i need to do... I have imported a 1 column list of
data from a text file into Excel and, using VBA have done various things
with it one of which is arranging the data into a table like format.
The reason I put "x columns and y rows" in my first question was because
the VBA program I am writing will be run with many text file data lists
and so each one will result in a different table size in excel. Anyway,
the task i now need to do is, via VBA, save the table as a .txt file but
the table format must be kept. By this i dont mean the font but simply
that the value in cell B2 must be in the same position in the text file.

Thanks

Have you tried to save to a PRN file? Like so:
someWorkBook.SaveAs Filename:="fubar.PRN", FileFormat:=xlTextPrinter

 

[Dave Peterson]

Position in a text file means different things depending on how your text file
is formatted.

Try saving it in .prn or .csv to see if that comes close to what you want.
Maybe you don't need a macro at all.