You want to have more control on how you write the values to a text file??

Some sample code to get you started:

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

riggi wrote:

Yes sir, this is a simple way of doing it. But, what if I want to
specify that copy Range("A1").Value to for instance 7th row and 9th
column in that text file. Is it possible??

thanks, I really appreciate.

Riggi

--

Dave Peterson