Excel VBA Google Translate Function with Detect Language!

Published: 20 April 2022
on channel: SyntaxByte

5,936

In this video, I show you how to use the Google Cloud Translation API with VBA to create a Google Translate user defined function in VBA which allows you to use the detect language functionality. This function can be used to translate text into many different languages inside Excel. The function is similar to the google translate function that is available in Google Sheets, but available to use with the power and familiarity of desktop Excel. Unfortunately, this solution as-is will only work on Windows.

A few things you will need to get this setup:

gcloud cli: https://cloud.google.com/sdk/docs/ins...
Cloud Translation API Setup: https://cloud.google.com/translate/do...
VBA-JSON Library: https://github.com/VBA-tools/VBA-JSON

Written tutorial: https://syntaxbytetutorials.com/excel...

On this page of the site you can watch the video online Excel VBA Google Translate Function with Detect Language! with a duration of hours minute second in good quality, which was uploaded by the user SyntaxByte 20 April 2022, share the link with friends and acquaintances, this video has already been watched 5,936 times on youtube and it was liked by 38 viewers. Enjoy your viewing!

153