Ok, I am using oWorkBook.SaveAs to tell Excel to save a workbook. The file already exists, since I had to open it to make the changes in the first place, and I want to always overwrite the file when I'm done. Is there any way to either supress the overwrite prompt or tell it to yes always overwrite from inside the program? If I have to click yes on that prompt after every single transaction I process it will be a pain.

And before you ask, yes, I need to save it after each one, because it pulls the information that goes into the sheets off a form that is changed from one transaction to the next.

If you need to see the code, let me know.