Member Avatar for love_dude1984

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
  • 89 Views
  • 3 Weeks Discussion Span
  • Latest Post Latest Post by love_dude1984
Member Avatar for Jupiter 2

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

Member Avatar for love_dude1984

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.