Error catching and repeat macro

Hi All,

I am running a series of macros including 4 downloads - when I run the series I am getting a run time 1004 error with the download but when I then go to debug there is nothing wrong with the code and it runs normally when I click play. Is there a line of code I can put in to catch the error and repeat the code rather than having to go into vba everytime?

The download is essential so I do not want to skip over it I just want it to be repeated until it works.


My code is;

Please Login or Register  to view this content.

You could put an anchor (ie ErrorHandler: ) before the code that is erroring out and put a statement like

Please Login or Register  to view this content.

If you did that I would build in a counter that counts the number of errors and exits the sub if a certain number is reached to avoid a possible infinite loop.

Ok....so what would the full new code read like please?

Unsure

Apologies - I am in some aspects but I am learning as I go along.

Thanks for this code - going to test during today and i'll come back to you

No joy, still throwing up the 1004 error saying the file cannot be found for one of several reasons.

I have moved this macro to be the very first one and it has worked fine - just having got a clue why the good code is throwing up errors yet working??

Run-time error '1004': Microsoft Excel cannot access the file 'L2C.xlsx'. There are several possible reasons:
•The file name or path does not exist
•The file is being used by another program.

and then it highlights this line of code - have moved the macro in the list and has worked since 3 times. Any ideas or an anamoly?

Please Login or Register  to view this content.

At a URL so it says the URL cannot be found, yet when I go into the code it works fine - hence the confusion