Excel VBA does not save file even when prompt says it will

I have an Excel file that generates reports using VBA. A portion of that process copies data from 1 file to append into another then saves the destination file. The process works on many machines with varying combinations of Windows and Excel. It has now decided to stop working for 2 of my users. These 2 users recently received new desktop computers with 32 bit Windows 7, MS Office 2013 (15.0.4787.1002).

For these 2 users, the VBA prompts with the "Do you want to Save the file?" message. When they click Yes, the procedure completes but the file is not saved. All other users do not get this prompt, the file just saves and closes.

I looked online for updates that cover this behavior and found nothing relating to this problem.

The VBA Code contains:

Application.ScreenUpdating = False
Application.DisplayAlerts = False
…
Workbooks(ModelFile).Close SaveChanges:=False
Workbooks(CurrFile).Close SaveChanges:=True
MsgBox ("Destination Updated")
…
Application.StatusBar = False
Application.DisplayAlerts = True
Application.ScreenUpdating = True

CurrFile closes, but without any changes.

Is there an update to apply or a setting we can change that will fix this behavior?

Recent Questions...