Macro entry to choose "yes"

[Jimmy59601]

I used the Record Macro feature in Excel 2013 to create a macro to do a Save as of a workbook to another file. However, the macro stops at the point where I'm prompted to replace the existing file, where I would click "yes." I copied the code below, and perhaps someone can tell me how to make the macro enter "yes" and then exit Excel. I want to save a file named z-Bank.xlsx as x-Bank.xlsx Thanks!

Sub SaveAS()
'
' SaveAS Macro
'
' Keyboard Shortcut: Ctrl+s
'
ChDir "W:"
ActiveWorkbook.SaveAS Filename:="W:\x-Bank.xlsx", FileFormat:= _
xlOpenXMLWorkbook, CreateBackup:=False
End Sub

 

[V_Malkoti]

Try:

Sub SaveAS()
'
' SaveAS Macro
'
' Keyboard Shortcut: Ctrl+s
'
ChDir "W:"
[COLOR=#0000ff]Application.DisplayAlerts = False[/COLOR]
ActiveWorkbook.SaveAS Filename:="W:\x-Bank.xlsx", FileFormat:= _
xlOpenXMLWorkbook, CreateBackup:=False
[COLOR=#0000ff]Application.DisplayAlerts = True[/COLOR]
End Sub

 

[Jimmy59601]

Thanks! That works, although Excel does not exit at the end.

 

[My Aswer Is This]

Try this:

Sub SaveAS()
'
' SaveAS Macro
'
' Keyboard Shortcut: Ctrl+s
'
ChDir "W:"
Application.DisplayAlerts = False
ActiveWorkbook.SaveAS Filename:="W:\x-Bank.xlsx", FileFormat:= _
xlOpenXMLWorkbook, CreateBackup:=False
Application.DisplayAlerts = True
Application.Quit
End Sub

 

[Jimmy59601]

I'm afraid it no longer "saves as," and still won't exit Excel. The macro apparently completes, but the first workbook remains open.

 

[My Aswer Is This]

So your now saying you have more then one workbook open? I never saw that in your original script. What do you want to do with the second workbook?

I'm afraid it no longer "saves as," and still won't exit Excel. The macro apparently completes, but the first workbook remains open.

 

[Jimmy59601]

So your now saying you have more then one workbook open? I never saw that in your original script. What do you want to do with the second workbook?

Sorry for the confusion. No, only one workbook is open: z-Bank.xlsx. After I run the latest code, it stays open and the Save as does not work, in that the target of the Save as does not update.