+ Reply to Thread
Results 1 to 2 of 2

Translate Excel Macro to be Google sheet friendly

  1. #1
    Registered User
    Join Date
    06-05-2012
    Location
    usa
    MS-Off Ver
    Excel 2007
    Posts
    37

    Translate Excel Macro to be Google sheet friendly

    Hi All,

    Can anyone help me translate this Macro which is in excel to be utilized within Goggle Sheet ?



    Please Login or Register  to view this content.
    Last edited by ctguards1987; 08-05-2022 at 10:51 AM.

  2. #2
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: Translate Excel Macro to be Google sheet friendly

    Excel macros are based on VBA, Google Sheets macros are built in Apps Scripts which are based on RE2 Javascript... in other words they are completely different languages and cannot be converted in the way you might think is possible.

    You will need to have the script completely rewritten, and for that to happen you will need to:
    1. give Editor access to a copy of your file
    2. ensure the sample file has EXACTLY the same structure and sample data as would be in the original.
    3. give thorough explanation of what you need the script to do
    4. accept that although it is possible to replicate the overall functionality, it doesnt mean the app script will behave exactly same, AND some things are not possible to do the same
    5. accept that you cannot convert apps script back to excel VBA
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]

+ 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 to Google Translate Chinese words to English
    By oreosamosa in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-07-2021, 02:47 PM
  2. 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
  3. 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
  4. 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
  5. 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
  6. Upload excel sheet to google translate (and pull the result) via VBA
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-08-2017, 04:02 PM
  7. need Google Translate in Excel 2003
    By appu_gusai in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-03-2013, 08:27 AM

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