dear friends!

my current problem is as follows.

I'm in file #1 and run a macro which:
- opens file #2
- copies huge bulk of data
- goes back to file #1 and pastes this huge bulk of data
- goes to file #2 and closes it.

the problem is that before closing file #2 it asks me if I need this
huge piece of info in Clipboard, which interrupts the whole process. I
use Application.screenUpdatig = false in the beginning of a macro, but
it doesn't work in this case.

any suggestions how to avoid all the questions from computer?

thank you.


--
andrei.aksenov@
------------------------------------------------------------------------
andrei.aksenov@'s Profile: http://www.excelforum.com/member.php...o&userid=21110
View this thread: http://www.excelforum.com/showthread...hreadid=389019

Hi

Try
Application.DisplayAlerts = False

Hope it helps
Michael
"andrei.aksenov@" wrote:


dear friends!

my current problem is as follows.

I'm in file #1 and run a macro which:
- opens file #2
- copies huge bulk of data
- goes back to file #1 and pastes this huge bulk of data
- goes to file #2 and closes it.

the problem is that before closing file #2 it asks me if I need this
huge piece of info in Clipboard, which interrupts the whole process. I
use Application.screenUpdatig = false in the beginning of a macro, but
it doesn't work in this case.

any suggestions how to avoid all the questions from computer?

thank you.


--
andrei.aksenov@
------------------------------------------------------------------------
andrei.aksenov@'s Profile: http://www.excelforum.com/member.php...o&userid=21110
View this thread: http://www.excelforum.com/showthread...hreadid=389019