connecting wordpad and excel

[Guest]

I have a wordpad document, which I first import to excel and then change some
numbers in it, using a macro. When I import the document in excel, I have to
sort it into columns. Example:
wordpad line: aaaa;12;2;;;;;bbb;;;xx
converts to: aaaa 12 2 bbb xx
then I change one of the numbers.
Does anyone know, how can I convert (or export) the changed excel file back
to the wordpad format (as it was before, but with the changed numbers)?

 

[Roger Govier]

Hi Jan

Download a copy of Earl Kiosterud's Text Write program from
http://www.smokeylake.com/excel/text_write_program.htm