Run-Time Error '-21474417848 (80010108)': Automation Error

Hi guys. First of all, i want to apologize for my bad english. i understand very well, but it is dificult for me to say correct what i want.

I have this error in my Excel file, when i run a macro:

Please Login or Register  to view this content.

I use Microsft excel 2010 with Sp1, x64 version. I have Windows 7 Ultimate. I try my excel file on other system, with x86 default Excel 2010. The same problem.

I will explain in few words what my macro doing:

I extract some data from the internet website, using a link witch my macro open with webquery, and copying the data from internet in same worksheet. Then, do it again, until no more link are.

I will post here the code, maybe you can find were is the problem:

Please Login or Register  to view this content.

Here i think is OK.

The all 4 macro witch i calling in this VBA code are practically the same, but the link URL adress is diferent, so i need to create these 4 aditional macro code.

Please Login or Register  to view this content.

This is one of the 4 macro witch i'm calling.

Now, when the error apear ?

Sometimes, after the first calling macro, sometimes, after the second macro, sometimes after the third macro, sometimes all did well, with no errors.

When my file crashed, i can exit, choose restart or close the Excel file.
When i choose restart, the Debug apear, and the code line

Please Login or Register  to view this content.

was highlighted with yellow. I think here is the error, but i couldn't find the correct solution.

Thank in advance !

I forgot to mention that, in the second macro witch i posted (AH), the cells from this code

Please Login or Register  to view this content.

contains formulas.

Nobody yet ?