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.


phillip harrison wrote:

Dave, Thanks for the reply and I have checked out Tushar Mehta's site
but unfotunately you need to download the code in a zip file and as Im
at work our internet settings prevent any downloads.

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

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

--

Dave Peterson