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?