Force Saving an Excel file

[rebie]

OK, so the more I get into this, the fancier I'm trying to make things...

So in my script I cycle through a list of potential member numbers from an Excel file. If a number comes up as already in use, I write the member's name in the cell adjoining the number. This works fine.

At the end of the script, I save the file with appExcel.Save. But I get this Excel dialog box "A file named 'RESUME.XLW' already exisits in this location. Do you want to replace it?"

RESUME.XLW is not the name of my workbook. This must be a temp name...? If I answer Yes in the dialog, it saves the changes to my workbook.

But how can I have it just Save it without prompting me?

 

[IknowMe]

before you save try

appExcel.displayalerts = false

Wow, I'm having amnesia and deja vu at the same time.
I think I've forgotten this before.

 

[rebie]

Bingo again!

Thanks.

 

[Skie]

If you're coding it in Extra Basic, remember to turn that back on when you're done. If it's Excel's VBA, then it will automatically set it back to true when the sub/function is finished.