0

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

2
Contributors
2
Replies
4
Views
8 Years
Discussion Span
Last Post by love_dude1984
0

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

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.