+ Reply to Thread
Results 1 to 2 of 2

Google Translate Function - quick question on syntax

  1. #1
    Forum Contributor
    Join Date
    08-25-2015
    Location
    London
    MS-Off Ver
    MS 365
    Posts
    215

    Question Google Translate Function - quick question on syntax

    Hi team,

    So I found this super great function to translate copy in Excel using

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    I found all "source" and "target" languages on a google translate page. If I want to translate from, let's say, English to German, the formula would look like:

    Please Login or Register  to view this content.
    This works well, however, it only works if "en" and "de" are "hardcoded" in the formula. If I use a variable here it doesn't work, even if those cells contain "en" including the quotation marks. I've also tried to use & to append the quotation marks before and after the referenced cell, but that doesn't seem to work either.
    Is there anyone who knows how to tweak this code so I can reference a cell for the "en" and "de" values?

    Thanks so much!

  2. #2
    Forum Contributor
    Join Date
    08-25-2015
    Location
    London
    MS-Off Ver
    MS 365
    Posts
    215

    Re: Google Translate Function - quick question on syntax

    False alarm! I got it to work. YAAY.

    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)

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. Google Translate Macro Function - How to rafear to Cell and/or Text in Quotes?
    By pacosalasv in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-07-2020, 03:11 PM
  3. Translate English to French without using Google Translate
    By shaunafink in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-29-2019, 12:08 PM
  4. Translate text from cell using Google translate (2)
    By Andreea1234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-31-2019, 07:36 AM
  5. Google Translate VBA Function
    By beardguy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-06-2018, 06:17 PM
  6. [SOLVED] Get Google translate Function isn't working anymore
    By Ravana in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-16-2015, 01:39 PM
  7. Quick Syntax Question
    By UNOTech in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-18-2005, 01:06 PM

Tags for this Thread

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