+ Reply to Thread
Results 1 to 3 of 3

Converting vba code into google spreadsheet script:dynamic dropdownlist

  1. #1
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    MS Excel 2021 / 365
    Posts
    1,238

    Converting vba code into google spreadsheet script:dynamic dropdownlist

    Hi all of you,

    In the below mentioned link there are vba codes which is needed to be converted into google spreadsheet script code.The entire discussion is in link given below :

    http://www.excelforum.com/showthread...t=#post3932736

    The vba code is recd by one of the great forum contributor whose name is mentioned in it.And I am thankful that till date I am using it.I am also simulateously working in google spreadsheet and would like to achieve same result of excel function in google spreadsheet too.

    Hope any forum contributors helps me in getting solved.The link to google spreadsheet is mentioned below :

    https://groups.google.com/a/googlepr...ductforums.com

    Google spreadsheet link >>

    https://docs.google.com/spreadsheets...it?usp=sharing

    Hoping for the best.

    suresh

  2. #2
    Registered User
    Join Date
    07-01-2016
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    1

    Re: Converting vba code into google spreadsheet script:dynamic dropdownlist

    VBA can read/write Google Spreadsheet via GSpread.NET.
    It opensource library works with Google Sheets by using Microsoft Excel API.
    You do not need to rewrite all the code just add:

    Set objExcel = CreateObject("GSpreadCOM.Application")

    // Name - User name, any you like
    // ClientIdAndSecret - `client_id|client_secret` format
    // ScriptId - Google Apps script ID
    app.MailLogon(Name, ClientIdAndSecret, ScriptId);

    see examples: http://scand.com/products/gspread/tutorial.html

  3. #3
    Registered User
    Join Date
    03-05-2018
    Location
    PH
    MS-Off Ver
    2013
    Posts
    1

    Re: Converting vba code into google spreadsheet script:dynamic dropdownlist

    Hi sir, i'm getting an activex component can't create object error. any suggestions?

+ 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. Problem with converting JSON into Google Spreadsheet
    By HannibalLec in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 05-06-2015, 07:54 AM
  2. Problem with converting JSON into Google Spreadsheet
    By HannibalLec in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-06-2015, 07:54 AM
  3. [SOLVED] How do you code in VB script to extract data from all worksheets in an Excel Spreadsheet t
    By rrusr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-24-2013, 08:08 PM
  4. google spreadsheet need function/code to pull data from one sheet to another
    By venusrena in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 04-27-2013, 04:48 AM
  5. Replies: 4
    Last Post: 08-05-2010, 01:09 PM

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