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

--
HTH
Nick Hodge
Southampton, England



"Nick" wrote in message
om...
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.

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

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

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.

"Nick Hodge" wrote in message ...
Nick

Not sure if

Application.CutCopyMode=False

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

--
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 :)

Nigel

Indeed it will not, but the OPs original request was to stop that particular
warning, not all warnings in the code.

Granted, Application.DisplayAlerts works, but he may have wanted to show
some, save workbook, etc.

--
HTH
Nick Hodge
Southampton, England



"Nigel Brown" wrote in message
om...
"Nick Hodge" wrote in message
...
Nick

Not sure if

Application.CutCopyMode=False

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

--
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 :)