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.