Greetings,

I have a small request, I'm trying to save a file to my C drive and then get
it to save to my G drive. My question is ....
how do I get it to save to the G drive without Microsoft's drop down box
confirming (Yes) to replace the file?

Here is my code:

Sub Save()
ActiveWorkbook.Save
ChDir "G:\Excel Files"
ActiveWorkbook.SaveAs Filename:="G:\Excel Files\Audit Highlights.xls"
ChDir "c:\Temp 1"
End Sub

Any help would be greatly appreciated.