Hi

ActiveWorkbook.SaveAs newfilename

If newfilename already exists at the saving location, a prompt will pop up
to confirm overwrite. Can I say Yes through the codes instead of manually
clicking on the Yes button ?

Thanks
Steve