Translate code takes long time

Hello experts
I was searching for a code that translates based on google translation
Here' the code but it took long time and no results for me

Please Login or Register  to view this content.

Any help in this topic please?

Maybe change

this
Application.Wait (Now + TimeValue("00:00:03")) to this
Application.Wait (Now + TimeValue("00:00:01")) to buy you a few seconds.

and if you know what you're translating then maybe change the #auto to #fr (for French) or whatever it is as I assume the auto feature takes time to detect the correct language.

I tried this on a small subset and both worked but how mch time is really saved is probably a function of the complexity of the phrases you have to translate.

Thanks Mr. Crooza for reply
I am facing the following message and tried every option (Yes - No - Close the message) and nothing happened ..
The words I would translate is very simple for test ..
001.png

Thanks I could fix this problem and disabled security warning through this link in the last post
http://stackoverflow.com/questions/8...-was-delivered

Another fix to the code I replaced http with https

Thanks a lot for help .. Problem Solved

Great. it worked for me but as you said it took some time

Thank you very much Mr. Crooza
At first it took long time without any results .. After changing http to https and disabling the security alert it works fine and give me results

Was it working with you by using http as posted in first post?