+ Reply to Thread
Results 1 to 5 of 5

VBA to google script/Javascript?

  1. #1
    Registered User
    Join Date
    05-04-2022
    Location
    Berlin, Germany
    MS-Off Ver
    2016
    Posts
    18

    VBA to google script/Javascript?

    Hello everyone,

    I would like to convert a VBA code to google sheets. I would like to know how difficult do you think it is to convert the entire code, as I have 0 knowledge in google script. Would you suggest me to study the syntax and to convert the code step for step? Or is there an easier way? I have read it should be possible with https://scand.com/products/gspread/ , but I have no idea how it works. I would be very thankful for your help.

  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: VBA to google script/Javascript?

    VBA is a completely different language to RE2 Javascript, furthermore there are functions available in VBA (especially those for Windows) that have no equivalent in RE2 Javascript, so it will be pointless to learn both languages in the hope of transliterating them.

    If you read the site properly:
    GSpread.NET is a fast and easy to use library designed for working with Google Spreadsheets by using the well-known API from Microsoft Excel.
    This does NOT mean that it translates VB script to RE2 Javascript.

    Other than the fact that google sheets uses Apps Scripts, Apps scripts can also be used by other Drive services.. Docs, Forms, Slides, Gmail, and the list goes on. So that linked site you have shown will only facilitate one small slice of what Apps Scripts will do if you implement it correctly.

    In short.. if you think you can simply transliterate VB to RE2 Javascript, or expect the same functionality by installing some software on your computer then you are sadly mistaken.
    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]

  3. #3
    Registered User
    Join Date
    05-04-2022
    Location
    Berlin, Germany
    MS-Off Ver
    2016
    Posts
    18

    Re: VBA to google script/Javascript?

    janmorris so I have no choice but to study the syntax of Google Apps Scripts I guess? Do you know a good website?

  4. #4
    Registered User
    Join Date
    01-12-2023
    Location
    Lithuania
    MS-Off Ver
    10
    Posts
    6

    Re: VBA to google script/Javascript?

    Or you can hire someone to do it for you, it will save your time. You can find freelancer on <deleted by moderator>, it will cost not so much.
    Last edited by 6StringJazzer; 01-12-2023 at 04:50 PM.

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: VBA to google script/Javascript?

    Quote Originally Posted by davewhite View Post
    Or you can hire someone to do it for you
    We offer paid services on our Commercial Services page. We do not allow links or references to any outside sites that charge for products or services.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. [SOLVED] Google sheets script to download file and save it to google drive folder and use it's data
    By western in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 5
    Last Post: 01-18-2021, 01:31 PM
  2. Translate a piece of code from VBA to JavaScript [for Google Sheets]
    By drivegol in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 03-05-2020, 12:28 AM
  3. Translate a piece of code from VBA to JavaScript [for Google Sheets]
    By drivegol in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-22-2019, 07:23 AM
  4. How to scroll through a google sheet using javascript
    By ctgalitzky in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 02-23-2019, 08:33 PM
  5. Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets
    By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-22-2018, 02:06 AM
  6. Looking for a way to populate cells based off multiple conditions
    By joker5893 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-06-2016, 12:32 PM
  7. [SOLVED] Google excel script help
    By Ditch1983 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 01-21-2015, 10:30 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