Modify existing code to identify language

[NiallJG91]

Hi All,
I recently found code on this site, linked below, which translates the contents of a cell using Google Translate.
This is great functionality, and I am wondering is it possible to modify the code so that the auto detected language is returned as the result instead of the translation?

Google Translate Macro Function - How to rafear to Cell and/or Text in Quotes?

Any advice would be gravely appreciated!

 

[John_w]

I don't think that code can be modified to identify the input language.

Probably the easiest and most reliable method is with the Google Translation API - specifically the detect 'method':

Detecting languages (Basic) | Cloud Translation | Google Cloud

cloud.google.com

You need a Google Account and project, as explained on that page, and you could use the free trial.

There should be some posts on this forum showing how to call a Google API using VBA and the code for the Translation API should be similar.

 

[johnnyL]

Maybe, encorporate a webscrape on the Google translate site of the Language found after the String is transmitted to the Google translator?