• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
VBA coding to convert language
#1
Hello everyone,



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


Vijay Kumar Smile


Attached Files
.xlsx   New Microsoft Excel Worksheet (2).xlsx (Size: 9.93 KB / Downloads: 22)
  Reply
#2
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.
  Reply
#3
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
  Reply
#4
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.


Attached Files
.xlsm   Translating tool.xlsm (Size: 50.97 KB / Downloads: 68)
  Reply
#5
(08-Oct-2017, 12:08 AM)Lovedeep sharma Wrote: 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.
  Reply
#6
(08-Oct-2017, 09:04 AM)Mohit Sharma Wrote:
(08-Oct-2017, 12:08 AM)Lovedeep sharma Wrote: 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.
  Reply
#7
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 Idea 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 Smile
  Reply
#8
(08-Oct-2017, 12:08 AM)Lovedeep sharma Wrote: 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
  Reply


Related Topics
Topic Author Replies Views Last Post
Sign-in VB Editor Convert currency number to words Inderjeet Pal 1 1,314 03-May-2019, 01:23 PM
Last Post: Vivekananda Sinha
  External Application VBA Coding for Outlook Mohit 1 1,712 05-Jul-2018, 10:06 AM
Last Post: Vivekananda Sinha
  Mail Outlook Coding Amit sharma 3 2,684 25-Feb-2018, 09:59 PM
Last Post: Lovedeep sharma
  Data Extraction Search Data in Excel and Paste in Next sheet in Vba coding Mohit Sharma 1 2,255 10-Nov-2017, 10:08 PM
Last Post: Vivekananda Sinha
  Copy and Paste Delete Blank Rows only table in Vba coding Mohit Sharma 1 2,281 04-Nov-2017, 08:38 AM
Last Post: Vivekananda Sinha
  Pivot Table Make Pivot table from Vba Coding Mohit Sharma 3 2,515 30-Oct-2017, 11:52 AM
Last Post: Harshit
  Others Total Sum in Merge Cells in vba coding Mohit Sharma 4 3,308 13-Oct-2017, 03:37 PM
Last Post: Mohit Sharma
  Number Format Need a 2 Function Convert Numbers to word in vba coding Mohit Sharma 2 2,631 09-Oct-2017, 01:38 PM
Last Post: Mohit Sharma
  Number Format Thousand Separators in Vba Coding Mohit Sharma 3 3,777 02-Oct-2017, 06:59 PM
Last Post: Mohit Sharma
  Data Extraction Custom List in Vba Coding Mohit Sharma 1 2,303 19-Sep-2017, 09:01 PM
Last Post: Vivekananda Sinha
  Find and Replace Special Character convert to blank RANVEER SHARMA 5 3,450 23-Aug-2017, 06:54 PM
Last Post: Lovedeep sharma

Forum Jump:


Users browsing this topic: 1 Guest(s)