Hi.
with reference to my previous posts, im able to write a text file with a specific values from excel sheet. i just wanted to knw how to get rid of the prompt of " there is an existing file, do you want to overwrite it ?"

i tried Application.Displayalerts=false mathod. it works for deleting or modifying the excel sheets..but its not working with the text file..

can anybody suggest me sm good ideas???

thnx...

Do you write directly to a text file or do you save the worksheet as a text file? It sounds like you SaveAs XXX.txt because you don't get messages if you write directly to a text file.

Open as TextStream
........
Close

hey thnx for replying..bt i have solved it in my own way..thnx for helping..