Use sendkeys in save as macro

Hello,

i've written a macro to copy the "temp" sheet of a workbook to a new workbook and then save tht workbook to an existing file. i get the "do you want to replace existing file" msg box. Using sendkeys i need to over ride the msg box so the user doesnt have to click yes everytime when running the macro.

help is much appreciated.

i also need to schedule a particular workbook and a macro in that book to be run every night at 12.

thanks in advance