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?
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks