How to catch errors from Google Translate

Hi,
I have created a macro translator (using help from this forum, so thanks) - a basic background is it reads through a number of rows in Column A, translates and puts the output in Column B. Basic but effective. It worked fine last week, I've not changed the code but now it's just returning blank data in Column B - I need to be able to check the return code/error code returned from the google translate and display a message if there's a problem but I've no idea how to do this - I've included the code in case it's any use......

Please Login or Register  to view this content.

I'm using the following test data in an excel spreadsheet:

Verbatim
I love this products but price is to high
product ruined my marble worksurface
dishwasher tablets are ruining my dishes
Verbraucher kritisiert geändertes Produkt.
Produkt muss mehrfach aufgetragen werden. Riecht nach Katzenurin.
Riecht nach Duftstein!
VB gefällt der Sprühnebem vom Produkt nicht.
allergische Reaktion durch feinen Sprühnebel
ich bekomme Atembeschwerden!
Funktionert nicht
Vb'in schreibt dass das Viss Produkt sie nicht überzeugen konnte.
Ein permanentes Drehen des WC-Steins ist n. mögl. Verfärbungen Toilettenrand.
Jetzige Flasche riecht anders und ist wässriger.





Any help would be much appreciated as I'm supposed to be presenting this to my boss soon and I've told him it works!
Cheers
MrsMac

Hi Bernie,
Thanks very much for taking the time to test this out - much appreciated. I've just tried it from scratch and run the debugger while doing it and it seems I'm getting a subscript out of range error on the UBound(CLEAN_DATA) having a value of -1, but I must admit to being a bit out of my depth now!

Please Login or Register  to view this content.

This is while translating the first "Verbatim" comment - how can I tell if I'm actually getting something returned from the translator in 'CLEAN_DATA' because I can't seem to see it using the debugger......

Please Login or Register  to view this content.

Hi, This is what I get - Capture.PNG

Can you see that attachment ok?
Could there be a limit on the number of translations allowed or something daft like that? Since my code works for you, but doesn't work for me or anyone in my office, I'm starting to think it's something environmental here (or am cursed, one of the two!)......
Does the call to the application have a return code I can check maybe? how can I find that out? (Sorry this is my first venture into non-mainframe coding so am a bit out of touch!)
Thanks

Since you're violating google T&Cs and they charge for this, I suspect that they are applying restrictions. If you wish to use this commercially as you are doing then take a look at the unrestricted api here - along with pricing https://developers.google.com/translate/v2/pricing