Hello,</SPAN></SPAN>
I have a problem with a pop up on Excel 2007.</SPAN></SPAN>
When I send the command from another software (SAS) to save my Excel file, it asks me “Do you want to save the changes you made to…”.</SPAN></SPAN>
Well, yes I do, but I find quite annoying that you pop the questions, dear Excel.</SPAN></SPAN>
Additional information :</SPAN></SPAN>
Private Sub Workbook_BeforeClose(Cancel As Boolean)</SPAN></PRE>
ActiveWorkbook.Saved = True</SPAN></PRE>
End Sub</SPAN></PRE>
And </SPAN></SPAN>
Private Sub Workbook_Open()</SPAN></PRE>
Application.DisplayAlerts = False</SPAN></PRE>
End Sub</SPAN></PRE>
Those solutions haven’t been tested yet. But, ideally, I would like to avoid using VBA macros.</SPAN></SPAN>
Thank you for reading my message, and hopefully one of you will have a new proposition that doesn't involve VBA </SPAN></SPAN></SPAN></SPAN></SPAN>
Aline
I have a problem with a pop up on Excel 2007.</SPAN></SPAN>
When I send the command from another software (SAS) to save my Excel file, it asks me “Do you want to save the changes you made to…”.</SPAN></SPAN>
Well, yes I do, but I find quite annoying that you pop the questions, dear Excel.</SPAN></SPAN>
Additional information :</SPAN></SPAN>
- The Excel is located on a distant computer. The SAS software that launches the instruction also.</SPAN></SPAN>
- I have tried to disable the Solver Add-in, but the problem still occurs</SPAN></SPAN>
- I found on this forum different suggestions : </SPAN></SPAN>
Private Sub Workbook_BeforeClose(Cancel As Boolean)</SPAN></PRE>
ActiveWorkbook.Saved = True</SPAN></PRE>
End Sub</SPAN></PRE>
And </SPAN></SPAN>
Private Sub Workbook_Open()</SPAN></PRE>
Application.DisplayAlerts = False</SPAN></PRE>
End Sub</SPAN></PRE>
Those solutions haven’t been tested yet. But, ideally, I would like to avoid using VBA macros.</SPAN></SPAN>
Thank you for reading my message, and hopefully one of you will have a new proposition that doesn't involve VBA </SPAN></SPAN></SPAN></SPAN></SPAN>
Aline