+ Reply to Thread
Results 1 to 7 of 7

Translate multi language file to english using VBA code

  1. #1
    Registered User
    Join Date
    03-11-2013
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2010
    Posts
    97

    Translate multi language file to english using VBA code

    Hi

    I am looking for a VBA Code which should identify multiple languages in my file and translate it to English...

    Please advice

    Regards
    Kiran Kumar

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Translate multi language file to english using VBA code

    Suggest you figure out how to automate Google Translate.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Translate multi language file to english using VBA code

    Have a look at post number 3 by Marcol here:
    http://www.excelforum.com/excel-prog...-with-vba.html

  4. #4
    Registered User
    Join Date
    03-11-2013
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2010
    Posts
    97

    Re: Translate multi language file to english using VBA code

    The problem is that we have multiple rows with multiple languages... we couldnt even recognise the language in the table....
    So we need a macro that needs to identify the language and then translate it to english.

    Please suggest if at all there is a tool other excel which does this or VBA macro can perform this activity


    Cheers
    Kiran kumar

  5. #5
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Translate multi language file to english using VBA code

    Ah ok, this sounds familiar actually, I think you asked this already in another thread?

    Your best option is probably to utilize the code in the linked post above and change it to utilize google translates "detect language" function.

  6. #6
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Translate multi language file to english using VBA code


  7. #7
    Registered User
    Join Date
    07-10-2013
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2007
    Posts
    40

    Re: Translate multi language file to english using VBA code

    try this

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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