I have a method where I am automating Excel to do some range sorting and manipulation. After that work is complete, I want to save the workbook before continuing (e.g. oExcel.ActiveWorkbook.Save() ).
Unfortunately, Excel wants to interactively confirm if I wish to replace the existing file. Is there a way I can just force the save to occur without any confirmation? I couldn't find anything in the object reference docs that would help.
Laterness,
Jon
Jon Rosenbaum
Devcon Drummer