Network save error

[liampog]

Hi

I've set a workbook to automatically save the workbook every 10 minutes.

However, as the workbook is located on a network drive (which is connected via Wifi), sometimes connectivity means it comes up with the error message saying that it cannot be saved.

This then stops VBA from working until Excel is closed and opened again.

Is there any code that would ignore any error message if the save isn't possible, and it would then just try again in 10 minutes?

Thanks
Liam

 

[mole999]

I would think On Error Resume Next would work, or if you can detect the error by number you could use an Error Routine