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