I need a function that is going to hit the "Y" key for me. When I run a
certain macro, it wants to send a file to a certain location to update
it and replace the old one. During this I have to hit the "Y" key to
say yes. I want to add something to the script so I dont have to do
this and then finally the script will be able to run on its own without
me.

Trevor


--
Bowes813
------------------------------------------------------------------------
Bowes813's Profile: http://www.excelforum.com/member.php...o&userid=23779
View this thread: http://www.excelforum.com/showthread...hreadid=374160

Good evening Bowes13

Use this command at the start of your code:

Application.DisplayAlerts = False

and this at the end of your code:

Application.DisplayAlerts = True

This will force the macro to not ask you a question, but choose th
default option on your behalf (which would be OK - overwrite th
file).

HTH

Dominic

--
dominic
-----------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...fo&userid=1893
View this thread: http://www.excelforum.com/showthread.php?threadid=37416