On Error retry SaveAs x times

I have a macro that saves a file as a new name after form is filled out. The location that it is saved to is a SharePoint location and the SaveAs sometimes fails due to network connection issues. I would like for the code to wait a couple of seconds and retry the SaveAs step, maybe 5 times before erroring out if it still isn't successful after those 5 tries. I have been trying to test the error loop sections with this code to force it to error, but it seems to only run twice and then throws the 1004 error:

Please Login or Register  to view this content.

If this does what I think it should do, it will loop for 10 seconds and then pop-up message box with "did not save". But as I said above it only runs for 4 seconds and then raises the 1004 error box.

Any help is greatly appreciated.

Please use code tags. (forum rule #2)

I don't think you can do it the way you intended... once inside an error handler (wait), it will not simply "reset". When the code goes to "wait", it is in error handling mode, so your next error doesn't just trigger going back, it actually generates the error. Try this instead:

Please Login or Register  to view this content.

Note that the code does not require the ":" in the goto statement, just in the place where you use it as a label.

If you could, it would be good if you edit your post to add the tags, it will make it easier to read for others, and like you, they may read this later looking for a similar issue.
Great that you look for answers/solutions before asking!

Happy it worked out for you, please remember to mark the thread as solved if you are satisfied. Happy coding!

p.s. thanks for the rep.

Thanks for that

And my pleasure!