is it possible to wait and try again on error

[tryer]

I am having intermittant problems with my program failing when calling an email routine. I'm pretty sure I know where and why the error is occuring and (with help from here ) have tried a number of things to overcome the issue. It is very intermittant and may happen perhaps once out of every 10 times it is run. Basically my code copies a couple of worksheets to a new workbook, saves this then calls an email subroutine to create a new email message and attach the saved workbook.
I'm pretty sure that what happens is that sometimes (presumably depending upon PC speed and other processes running) the workbook is still saving when the email routine tries to attach the workbook, when this happens I I don't get the usual debug error, instead I get a runtime error, Application failed from which the only option is 'Exit' which then styops my code part way through.
I can overcome the issue by adding a wait of say 10 secs. before calling the email, however sometimes the code loops through 10-15 times so this adds considerably to the overall runtime.

What I am thinking is can I add a wait on error, something like:

Please Login or Register  to view this content.

I assume I can't call the routine from within itself but I hope this illustrates he kind of solution I am thinking of.

[royUK]

I would try to find out why there may be such a delay in saving

[Firefly2012]

If you're running that code from within Excel how are you saving the workbook? I ask because AFAIK VBA would be synchronous in this instance, so the workbook must have finished saving before further code is executed.

[tkowal]

Have you tried using the DoEvents function to yield to operating system......

Some times this works miracles on processes that take a long time ......