Others VBA coding to convert language

[Vijay Kumar]

Hello everyone,



I either need a function or subroutine to change English Language text in Taiwan Language. PFA....


Vijay Kumar

[Mohit Sharma]

Hi Vijay,

Please go to the Review Tab in Excel and click the (Translate) tools,it's requirement internet connection but any paragraph whatever length or language easily translate as per your requirement. I think it is simple way.

[Vijay Kumar]

Dear Mohit,


Thanks for a good to know information about review tab. However I am already aware,FYI the text which I wrote in my attachment,was being translated by that tab only. I need a vba code/function. Please help me out.

My name is Vijay Kumar
我的名字叫維賈伊 · 庫馬爾






Many thanks in advance.
Vijay Kumar

[Lovedeep sharma]

Hi,

I found a tool for Translate to multiple languages at once which fulfills the desired requirements .As the tool is using Google Translate, you need  internet connection when using this tool.

[Mohit Sharma]

Hi Lovedeep,

Very well, I have checked now this tool it's working but it's a little bit problem. suppose you want to translate English to Chinese(traditional) input any name is (Data_translatation_input Sheet) for example like:- My name is Mohit sharma or vijay kumar or loveedeep sharma so (My name is) translated but name is not translated i was checked is Google Translate same thing that tool. it's not your fault, I only inform you. If i wrong please reply me.

[Divesh rai]

Hi Lovedeep,

Very well, I have checked now this tool it's working but it's a little bit problem. suppose you want to translate English to Chinese(traditional) input any name is (Data_translatation_input Sheet) for example like:- My name is Mohit sharma or vijay kumar or loveedeep sharma so (My name is) translated but name is not translated i was checked is Google Translate same thing that tool. it's not your fault, I only inform you. If i wrong please reply me.

I also checked but Name is not showing as per their set language. It is showing same name in translation box not showing other language.

[Vijay Kumar]

Dear Lovedeep,


A bunch of thanks:-


Sincere thanks.
1)I am thankful to FIH club which is available 24X7
2)In the club Lovedeep, you've been very helpful always.
3)I am indebted to you.
4)I thank you from the bottom of my heart for being so thoughtful and eager to answer maximum questions.
5)Fortunately, I got change to be your class mate in SQL-Batch and learnt many positive things. So thanks for that as well.
6)You are a creative and supportive student of our institute.
7)honestly speaking English is neither my native language nor yours. But when
   I asked for help and you said "ANY TIME" with smiley face. I felt you have spoken thousand words for helping me and I understood everything.
8)Thank you for taking the initiative and getting it done.
9)This tool is working magnificently.
10)Can't express my happiness.  :D


With Regards,
Vijay Kumar

[Madhu]

Hi,

I found a tool for Translate to multiple languages at once which fulfills the desired requirements .As the tool is using Google Translate, you need  internet connection when using this tool.

Hi

Thanks for sharing this. I tried but it throws of an error .. it's asks to debug... At set oelement... Where we are adding an element tp... I am not sure how to fix this. Can u help