Translate function VBA

[abdulhaque]

Hi all,

After trying various VBA scripts I am stuck as none of them worked.

I am looking for a VBA function which will allow me to translate a cell and output translation to another cell. So for example if cell A1 had some text in Dutch, then if the function was used in B1 to translate to English, the resulting translation will be displayed in cell B1. The function parameters I would assume will need to be the source language, translated language, and the text to be translated.

Does anyone know of any working VBA functions to meet this reuqest? Also using the google translate engine in the script would be good.

Thanks

 

[Paul Ked]

A quick Google found this https://www.microsoft.com/en-us/translator/business/excel/

 

[Paul Ked]

And this https://download.cnet.com/Google-Translate-for-Excel/3000-18483_4-75759774.html