How to remove Excel popup

[Aline S]

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>

• 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

 

[RickXL]

It may be enough to get SAS to save the workbook before it tries to close it.

That way it will already be saved so has no need to ask.

 

[Aline S]

Many thanks for your answer.

Though, there is already a line of code in SAS that is supposed to do it.
And it works well on 90% of our subsidiaries
But not for this one. And it drives me nuts

 

[RickXL]

All I can think is that something happens to the spreadsheet after the SAVE command and before the EXIT command. Even if it is only a cursor move.

Have a look at this link. It might provide a clue.

"Save changes in <filename>" prompt even if no changes are made

 

[Kenneth Hobson]

What is the SAS code to "save" the Excel file? To avoid the popup, save and then close the file.

I suspect it is more of a SAS issue. I guess you may be doing something like: sas - "Save As" and "Close file" without using macro - Stack Overflow

 

[Aline S]

All I can think is that something happens to the spreadsheet after the SAVE command and before the EXIT command. Even if it is only a cursor move.

Have a look at this link. It might provide a clue.

"Save changes in <FILENAME>" prompt even if no changes are made

Indeed it could have something to do with it, because this page also talk about other problems I have ("A formula in the worksheet contains one or more invalid reference (…)”).</SPAN>
</SPAN>
I will investigate further into that.

What is the SAS code to "save" the Excel file? To avoid the popup, save and then close the file.

I suspect it is more of a SAS issue. I guess you may be doing something like:
sas - "Save As" and "Close file" without using macro - Stack Overflow

You suspect well.

And, answering to your question, I see something I haven't told you.
The popup appears in an Excel file I do not wish to save when I want to close it with the instruction : data _NULL_; file SYS; put "[CLOSE()]";

 

[Aline S]

Sorry for the inconvenience.
Indeed my problem as not been solved by a change, not in Excel, but by adding a data _NULL_; file sys; put "[ERROR(FALSE)]"; in the SAS code.