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???


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

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