VBA Saving Dialog Box is not closing

[camillaEne]

Hi,

I have a VBA code that loops through different files, making changes in them and then saving the files. When saving some of the larger files, I have a problem that the Saving dialog box will not close.
I save the following way:

Application.DisplayAlerts = False
Application.ScreenUpdating = False
Application.DisplayStatusBar = False
Application.EnableEvents = False

wb.SaveAs filepath, ConflictResolution:=xlLocalSessionChanges
wb.Close SaveChanges:=False

The file is saved locally on my computer, but this saving dialog box do not close (see picture). I need to press cancel in order for the code to proceed with the next file. Can I force it to close in my code? Or how to deal with this problem?

Thank you very much for helping!!

 

[Alex Blakenburg]

If

Hi. I do just change the original file, but when I used just "wb.save ..." this did not work better. Is this the solution you suggest?

If you need to save the original file, there is probably no point. I just thought it would be worth a try if you were using Save As in case it helped with any file locking.

 

[rlv01]

And make sense with the Application.Wait --> but I am wondering if the code will ever jump to this line if it is stucked in the "Wb.SaveAs", as the dialog box is not closing down?

Yes it will because the macro does not wait until the file operation completes, so the idea is to MAKE it wait as a test.

The other thing you might try is to use the debugger to single-step the save code

wb.SaveAs filepath, ConflictResolution:=xlLocalSessionChanges
wb.Close SaveChanges:=False

for the large problem file to see if you learn anything.