Saving problem

[CDirk]

I have an excel application that runs 24/24. During the day, there is a cycle that is run every 10 minutes. After that cycle, it is saved with the save command. For several weeks now, when saving, we have been getting a message on the screen every now and then saying that the file does not exist or has been moved. This message obviously blocks the operation of the cycles. I've already tried turning off Application.DisplayAlerts before saving, but that doesn't help.

Current code for saving:

  Application.DisplayAlerts = False
  If Dir(Wb.FullName) <> "" Then
    Wb.Save
  End If
  Application.DisplayAlerts = True

Anyone have any idea why we are getting this notification?

 

[Shortmeister1]

Try adding an ON ERROR RESUME NEXT before the save and an ON ERROR GOTO 0 after to disable it. Disabling the alert (which is good!) isn't the same as ignoring the error.

Are you writing the results to a log file? You should!

 

[CDirk]

Try adding an ON ERROR RESUME NEXT before the save and an ON ERROR GOTO 0 after to disable it. Disabling the alert (which is good!) isn't the same as ignoring the error.

Are you writing the results to a log file? You should!

Modified my code as specified. Problem persists. Only after clicking away the message does the code pass the error routine.......

 

[Shortmeister1]

Ho hum. Trying using SaveAs and try overwriting the file each time?

 

[CDirk]

This tip seems to work..... I have encountered the error once without blocking the application.
I'll follow it up for a while. The error doesn't happen daily now either.

Ho hum. Trying using SaveAs and try overwriting the file each time?

This tip seems to work..... I have encountered the error once without blocking the application.
I'll follow it up for a while. The error doesn't happen daily now either.

 

[CDirk]

Ho hum. Trying using SaveAs and try overwriting the file each time?

The error did not occur again. Thank you guys for the tip.