In this lecture, I would like to introduce you how to make Google Automatic Translator, a new VBA project lecture.
Let's take a look at the screen.
If you come to 'File' and go to 'Options' - 'Additional Functions', there is a button to add Excel Add-in.
Click 'Go' and then click 'Browse' to open a window to select a file.
Please download the ADD-IN file from your brother's homepage for free and add the file.
There is an additional feature called "ADDIN".
In the top right corner, there is a tab called 'My brother two Addin'.
Second, there is the ability to select a range or to translate an entire sheet.
Click anywhere in the cell, and then click on 'Google Translate Function Input Method'.
The existing language is recognized automatically. The selected language is identified as 'Hindi'.
If you select a language to translate, the result will be automatically reflected.
The Google translation function has been entered.
If you do the autofill, it will be automatically translated.
Above is entered in Japanese, below is entered in Chinese.
Google has the ability to automatically detect languages.
If you click the 'Auto detect' button here, you can translate all languages to 'Korean' regardless of the original language.
All languages are translated into Korean, regardless of Japanese or Chinese.
Second, Addin has the ability to translate entire sheets or ranges.
Clicking Detect original language automatically detects the original language of the selected range.
I will choose the language to be translated in German.
Click 'Translate entire sheet' to translate the entire range of the current sheet.
In this way, not only existing tables but also functions are retained, so you can use all functions after translation.
After selecting the range to be translated, this time, we will translate the translation language into English.
There is a table in Chinese. After selecting the range, please input the original language by automatic detection of original language.
Let's translate the language to "Korean."
In this lecture, I prepared an introductory video about creating a Google translation function to proceed to the next VBA project lecture.
In this project lecture, we will first look at how to create a Google translation function.
This tutorial will provide you with a tutorial that provides both sample files and macro code as before.
Both my brother and I have received much interest and encouragement and have exceeded 45,000 subscribers.
Please leave a comment below about the content of this video content.
Không có nhận xét nào:
Đăng nhận xét