Excel VBA Google Translate Function with Detect Language!

Опубликовано: 19 Октябрь 2024
на канале: SyntaxByte
5,936
38

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...