Hello,

I'm having an interesting yet seemingly easy to fix problem in an
Excel Addin that I have been developing. Within the Addin, I save the
current file as a temp file, and then I save it back to it's original
path. I also do the same thing in Microsoft Word. In Excel, I am asked
if I would like to overwrite the original file, whereas in Micrsoft
Word, the save takes place without any dialogs. I tried setting the
AlertBeforeOverwriting property of the excelApplication to false, but
it has no effect. Any ideas on this problem would be greatly
appreciated.

Thank You,
Rob Heinen

Here is the code:

excelApplication.AlertBeforeOverwriting = false;

excelApplication.ActiveWorkbook.SaveAs( tempPath, extension,
missing, missing, missing, missing,
XlSaveAsAccessMode.xlShared,
missing, missing, missing, missing, missing );

//resave as the original
excelApplication.ActiveWorkbook.SaveAs( origPath, extension,
missing, missing, missing, missing,
Microsoft.Office.Interop.Excel.XlSaveAsAccessMode. xlShared, missing,
missing, missing, missing, missing );

In VBA you can suppress this with

Application.DisplayAlerts = False
' do the save
application.displayAlerts = True

this is not a persistent setting, so it isn't a parameter you can set
outside of using code.

I am not sure it will work form .NET, so you might just need to delete the
file before doing the save.

--
Regards,
Tom Ogilvy


" wrote:

Hello,

I'm having an interesting yet seemingly easy to fix problem in an
Excel Addin that I have been developing. Within the Addin, I save the
current file as a temp file, and then I save it back to it's original
path. I also do the same thing in Microsoft Word. In Excel, I am asked
if I would like to overwrite the original file, whereas in Micrsoft
Word, the save takes place without any dialogs. I tried setting the
AlertBeforeOverwriting property of the excelApplication to false, but
it has no effect. Any ideas on this problem would be greatly
appreciated.

Thank You,
Rob Heinen

Here is the code:

excelApplication.AlertBeforeOverwriting = false;

excelApplication.ActiveWorkbook.SaveAs( tempPath, extension,
missing, missing, missing, missing,
XlSaveAsAccessMode.xlShared,
missing, missing, missing, missing, missing );

//resave as the original
excelApplication.ActiveWorkbook.SaveAs( origPath, extension,
missing, missing, missing, missing,
Microsoft.Office.Interop.Excel.XlSaveAsAccessMode. xlShared, missing,
missing, missing, missing, missing );

Thanks Tom,

That solved it. The DisplayAlerts property works in .NET also,
apparently. Thanks again.

-Rob


Tom Ogilvy wrote:
In VBA you can suppress this with

Application.DisplayAlerts = False
' do the save
application.displayAlerts = True

this is not a persistent setting, so it isn't a parameter you can set
outside of using code.

I am not sure it will work form .NET, so you might just need to delete the
file before doing the save.

--
Regards,
Tom Ogilvy