Set the DisplayAlerts property of your Excel object to False before calling the save method.
>All
>
>First off..please forgive me for asking so many questions but I'm learning as I go along here...
>
>Now..here's the issue that I'm having. I have a spreadsheet that I'm opening and then doing a SAVEAS on it. Problem is that the "already exists. Do you want to save file" dialog box appears.
>
>I have found the "CreateNewDocument" method so that I can overwrite the file.
>
>Question is: will the dialog still appear? Or are there any other ways of OVERWRITING a file and not displaying the dialog box?
>
>Thanks in advance!
>
>Nicky
>Elgin, IL