Insert a key function in VBA script

[Bowes813]

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

[dominicb]

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 the default option on your behalf (which would be OK - overwrite the file).

HTH

DominicB

[Bowes813]

What if my default is No?

[dominicb]

Hi Bowes813

What I said in my answer was correct, but I think perhaps I could have explained it a little better. this command will set your default value for the question to true and answer the question for you. Indeed, this is what the Excel 2003 help file has to say about the DisplayAlerts property:

"When using the SaveAs method for workbooks to overwrite an existing file, the 'Overwrite' alert has a default of 'No', while the 'Yes' response is selected by Excel when the DisplayAlerts property is set equal to True."

HTH

DominicB