+ Reply to Thread
Results 1 to 4 of 4

HELP : Translate from Arabic to English Using VBA & Microsoft Translate Azure Service

  1. #1
    Registered User
    Join Date
    03-22-2016
    Location
    United Arab Emirates
    MS-Off Ver
    2013
    Posts
    2

    HELP : Translate from Arabic to English Using VBA & Microsoft Translate Azure Service

    Hi Guys, Gurus and Geniuses

    I am a noob and need your help.

    My boss want to me to physically translate 2500 excel Arabic entries into English - one cell at a time using inbuilt translate function. It is driving me nuts.

    Does someone have VBA code that I can reuse. The aim is to read Arabic data from cell(A1) and get English translation pasted into cell(B1). The process should loop till end of the file.

    Microsoft has a translate service on azure market place. It would be wonderful if I can use it. Their quality is good and free account limits are 2,000,000 characters...which works well for me. Cannot charge company for this service.

    Please please please help.

    Regards

    dzdigger

  2. #2
    Forum Expert
    Join Date
    08-28-2014
    Location
    Texas, USA
    MS-Off Ver
    2016
    Posts
    1,796

    Re: HELP : Translate from Arabic to English Using VBA & Microsoft Translate Azure Service

    Most certainly not my code, I just remembered running across it awhile ago.

    Credit for writing the code appears to go to Patrick O'Beirne.
    I'm interested in starting a career working with VBA, if anyone knows of any opportunities!

  3. #3
    Registered User
    Join Date
    03-22-2016
    Location
    United Arab Emirates
    MS-Off Ver
    2013
    Posts
    2

    Re: HELP : Translate from Arabic to English Using VBA & Microsoft Translate Azure Service

    thanks. Will give it a shot.

  4. #4
    Registered User
    Join Date
    10-31-2013
    Location
    Brisbane
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: HELP : Translate from Arabic to English Using VBA & Microsoft Translate Azure Service

    For the record, it is easier to use Google Drive Sheets to do this:
    1) These are the language codes needed (create a 2nd sheet and paste in) for reference
    Afrikaans af
    Akan ak
    Albanian sq
    Amharic am
    Arabic ar
    Armenian hy
    Azerbaijani az
    Basque eu
    Belarusian be
    Bemba bem
    Bengali bn
    Bihari bh
    Bork, bork, bork! xx-bork
    Bosnian bs
    Breton br
    Bulgarian bg
    Cambodian km
    Catalan ca
    Cherokee chr
    Chichewa ny
    Chinese (Simplified) zh-CN
    Chinese (Traditional) zh-TW
    Corsican co
    Croatian hr
    Czech cs
    Danish da
    Dutch nl
    Elmer Fudd xx-elmer
    English en
    Esperanto eo
    Estonian et
    Ewe ee
    Faroese fo
    Filipino tl
    Finnish fi
    French fr
    Frisian fy
    Ga gaa
    Galician gl
    Georgian ka
    German de
    Greek el
    Guarani gn
    Gujarati gu
    Hacker xx-hacker
    Haitian Creole ht
    Hausa ha
    Hawaiian haw
    Hebrew iw
    Hindi hi
    Hungarian hu
    Icelandic is
    Igbo ig
    Indonesian id
    Interlingua ia
    Irish ga
    Italian it
    Japanese ja
    Javanese jw
    Kannada kn
    Kazakh kk
    Kinyarwanda rw
    Kirundi rn
    Klingon xx-klingon
    Kongo kg
    Korean ko
    Krio (Sierra Leone) kri
    Kurdish ku
    Kurdish (Soranî) ckb
    Kyrgyz ky
    Laothian lo
    Latin la
    Latvian lv
    Lingala ln
    Lithuanian lt
    Lozi loz
    Luganda lg
    Luo ach
    Macedonian mk
    Malagasy mg
    Malay ms
    Malayalam ml
    Maltese mt
    Maori mi
    Marathi mr
    Mauritian Creole mfe
    Moldavian mo
    Mongolian mn
    Montenegrin sr-ME
    Nepali ne
    Nigerian Pidgin pcm
    Northern Sotho nso
    Norwegian no
    Norwegian (Nynorsk) nn
    Occitan oc
    Oriya or
    Oromo om
    Pashto ps
    Persian fa
    Pirate xx-pirate
    Polish pl
    Portuguese (Brazil) pt-BR
    Portuguese (Portugal) pt-PT
    Punjabi pa
    Quechua qu
    Romanian ro
    Romansh rm
    Runyakitara nyn
    Russian ru
    Scots Gaelic gd
    Serbian sr
    Serbo-Croatian sh
    Sesotho st
    Setswana tn
    Seychellois Creole crs
    Shona sn
    Sindhi sd
    Sinhalese si
    Slovak sk
    Slovenian sl
    Somali so
    Spanish es
    Spanish (Latin American) es-419
    Sundanese su
    Swahili sw
    Swedish sv
    Tajik tg
    Tamil ta
    Tatar tt
    Telugu te
    Thai th
    Tigrinya ti
    Tonga to
    Tshiluba lua
    Tumbuka tum
    Turkish tr
    Turkmen tk
    Twi tw
    Uighur ug
    Ukrainian uk
    Urdu ur
    Uzbek uz
    Vietnamese vi
    Welsh cy
    Wolof wo
    Xhosa xh
    Yiddish yi
    Yoruba yo
    Zulu zu

    ----------
    Then on the 1st Sheet:
    Cell A1 enter phrase in Arabic to translate to English,
    Cell B1:
    =UPPER(GOOGLETRANSLATE(A1,ar,en))
    drag formula down in cells in B to automate this process for list of words in A column.
    ---------

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro: translate text from cell using google translate
    By Marc_excel_tips in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 01-05-2021, 06:18 AM
  2. translate to english
    By Baskar5353 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-29-2015, 09:40 AM
  3. Sample Translate English to Arabic Text Using MS Translate
    By pidyok in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-21-2013, 08:18 AM
  4. Need to translate from Arabic language to English
    By gaminguy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-26-2013, 09:27 AM
  5. Mac 2011 excel, need to translate column of over 1500 entries from Arabic to English
    By smarttech in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 05-09-2013, 06:12 PM
  6. Need to translate from Arabic language to English
    By gaminguy in forum Excel General
    Replies: 1
    Last Post: 01-10-2013, 05:22 AM
  7. [SOLVED] Translate formula to english
    By Mendz5 in forum Excel General
    Replies: 4
    Last Post: 08-23-2006, 09:49 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1