getting rid of of a pop-up massage box

  • Thread starter Thread starter Nick
  • Start date Start date
N

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

Not sure if

Application.CutCopyMode=False

will help, but if not, copy an empty cell in between actions should do it
 
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
 
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
 
Nick Hodge said:
Nick

Not sure if

Application.CutCopyMode=False

will help, but if not, copy an empty cell in between actions should do it

--
Click to expand...
Yes it will but it will not disable pop-ups for the entirity of the
macro. To achieve this, use:
Application.DisplayAlerts=False

HTH
Nigel
p.s Funny Freudian slip :)
 
Back
Top