If you really want to invent your own file format to store formatting info,
you will need to read/write it to file yourself using the Open statement.
It would probably be better to write a class to do this.

However, there are a number a format available that would save you the
trouble of creating you own; Rich Text Format, HTML, Word.
Depends what you are trying to achieve.

NickHK

"embirath" wrote in
message ...

Hi everyone

I want to write a procedure in VBA which reads information input by the
user into an Excel worksheet, then manipulate the data, and then finally
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 I
want to define the format of the text files myself inside the VBA
procedure. Does anyone know how I can do this?

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

Thank you!
Em


--
embirath
------------------------------------------------------------------------
embirath's Profile:
http://www.excelforum.com/member.php...o&userid=37202
View this thread: http://www.excelforum.com/showthread...hreadid=569171