View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
CST[_2_] CST[_2_] is offline
external usenet poster
 
Posts: 14
Default getting rid of of a pop-up massage box

Have you tried Application.DisplayAlerts = False?

(Nick) wrote in message . com...
I have made a macro in excel which opens a certain text file and gets
the data out of it. The problem is that I everytime get a pop-up
massage box which says that there is a large amount of information and
it asks me if I also want to save this information on the Clipbord.
How can I get rid of this. I've about 200 text files and the whole
proces goes automatically accept for this part.