G
Guest
I am using the following code to save the active workbook:
ActiveWorkbook.SaveAs Filename:="C:\MyWorkbooks\TempFile.xls"
How can I get it to select Yes if prompted to Replace the Existing File?
ActiveWorkbook.SaveAs Filename:="C:\MyWorkbooks\TempFile.xls"
How can I get it to select Yes if prompted to Replace the Existing File?