Saving an Excel File Without Getting Confirmation Box

[ctau]

This is probably a simple task but I just can't figure it out. I have created a procedure that opens an excel file makes some changes and then saves it. But when I try to save it tells me that it already exist and asks me if I would like to continue. Is there a way to avoid this dialog box. The line I am currently using to try to save is xlsApp.Save ("E:\edi SPREADSHEETS\EDI.XLS&quot. Thanks


CTAU

 

[dsi]

1. If the file does not exist;

xlApp.ActiveWorkbook.SaveAs Filename:="E:\ediSPREADSHEETS\EDI.XLS"

2. If you opened the file, modified it, and want to save the changes;

xlApp.ActiveWorkbook.Save

3. If you created a new file and want to overwrite the existing file then;

Kill("E:\ediSPREADSHEETS\EDI.XLS&quot
xlApp.ActiveWorkbook.SaveAs Filename:="E:\ediSPREADSHEETS\EDI.XLS"

Hope this helps!

 

[ctau]

Thanks, that did the trick.


CTAU