Are your cells in a contiguous range or are they scattered all around the
worksheet? If scattered all around, is there a regular pattern to them? It
would help if you could tell us the range you are wanting to save.

--
Rick (MVP - Excel)


"japfvg" wrote in message
...
Hi all,

Thanks to you all I've been improving in VBA so thanks again and great
this
forums exist.

Now I have a doubt and I'm not sure how to do it, I want to write a txt
file
with the information of some cells separating them with commas. I have
already use the worksheets.saveas function, the text file is generated
correctly but I llike to see if there is any other option, maybe like the
open function in order to write only the txt file.

Do anyone have any idea for doing this?

Thanks again