getting rid of of a pop-up massage box

[Nick]

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.

 

[Paul Robinson]

You've got a pop-up massage box at work? I want one!!
regards
Paul

PS throw in Application.CutCopyMode = False to clear the clipboard

 

[Mike Waldron]

Nick

I'd suggest this:

sub name()
Application.DisplayAlerts = False
your macro code
Application.DisplayAlerts = True
end sub

Turning DisplayAlerts to false will stop all of Excel's
warning messages.

Regards,
Mike

 

[CST]

Have you tried Application.DisplayAlerts = False?