Hi everyone

I want to write a procedure in VBA which reads information input by th
user into an Excel worksheet, then manipulate the data, and then finall
write out text files which have my own specified format. In other words
I do not want to write out csv files, or tab delimited files. Instead
want to define the format of the text files myself inside the VB
procedure. Does anyone know how I can do this?

I guess one way of doing this would be to read in the data, manipulat
it, and then create a new worksheet where all my formatted text is i
the first column. Thus when I write out the text file, it won't put an
commas or tabs where I don't want them. But this method seems a bi
tedious, so I'm wondering if you have any other ideas that would mak
the job easier.

Thank you!
E

--
embirat
-----------------------------------------------------------------------
embirath's Profile: http://www.excelforum.com/member.php...fo&userid=3720
View this thread: http://www.excelforum.com/showthread.php?threadid=56917