No "save changes" when exiting Excel 2003

[JimR]

I have a client using Office 2003, Win XP.
When the close Excel, they are no longer being prompted to "save changes"
even though they have made changes. Needless to say, they are quite upset
since they are losing the changes they made unless they manually save the
file before closing.
I have searched and have not been able to find any reference to this.

Any help would be greatly appreciated.
Jim

 

[Conan Kelly]

JimR,

Are you familiar with VBA and using the VBE.

If so, open the VBE, display the Immediate window, enter the following line
of code and hit enter:

msgbox application.DisplayAlerts

If a message box pops up that says "FALSE" then enter the following line and
hit enter.

application.DisplayAlerts = True

If the message box said "TRUE", then I don't know what else it could
be.........sorry!

HTH,

Conan

 

[JimR]

Conan,

An AMAZING little tidbit of info. Can't thank you enough. This helped us
narrow down the problem. This only occurs when using info exported from Act.
When you check the spreadsheet created by an Act export, the value is in fact
false.
All I need to do now is figure out how/why Act does this. I suspect they are
using an Excel template with this setting set to false by default.

Thank you!!

 

[Conan Kelly]

JimR,

Act probably is running some code (macro) to export to XL.

Normally developers will toggle settings like these off & on in the code.
Near the beginning would be a command like this:

application.DisplayAlerts = FALSE

and there should be a command like this near the end of the code:

application.DsiplayAlerts = TRUE

Now, the code that ACT is using either doesn't have the second command
turning the setting back on (not very likely), or an error occurs during
execution that stops the execution so the second command doesn't get
executed, thus leaving the setting turned off. Also, there could be error
traping in the code that bypasses the second command when an error occurs,
thus leaving the setting turned off.

HTH,

Conan