+ Reply to Thread
Results 1 to 4 of 4

converting excel macro into a google docs script??

  1. #1
    Registered User
    Join Date
    01-22-2014
    Location
    Potosi, MO
    MS-Off Ver
    Excel 2013
    Posts
    64

    Question converting excel macro into a google docs script??

    Does anyone know what I would need to do in order to convert this macro into a working google docs script?

    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    01-22-2014
    Location
    Potosi, MO
    MS-Off Ver
    Excel 2013
    Posts
    64

    Re: converting excel macro into a google docs script??

    anyone have ideas?

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,811

    Re: converting excel macro into a google docs script??

    As I understand it (and I don't use google docs much), Google docs uses Javascript as its macro language. So, converting your VBA macro to something Google docs can use is as "simple" as converting the code from VBA to Javascript.

    If you are familiar enough with each language, then you should be able to do it by hand.

    An internet search for "VBA to Javscript" converter finds a couple of possible converters, but they seem expensive. I do not know how well they work, either.

    Your code looks like a recorded macro. I searched for "google docs macro recorder" and could not find anything useful. I found a couple of generic macro recorders (again they look expensive), but I know nothing about them.

    To sum up, if you are not already familiar with Javascript, then I think you are at the point of needing to learn enough Javascript to put the code into Google.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: converting excel macro into a google docs script??

    Hi,

    Good question!! I find an answer on Quora..
    https://www.quora.com/Can-you-run-ma...-Google-Sheets
    There are links to helping with your question on the site above.
    The important sentence is:
    You can accomplish a lot of tasks with Google Apps Script but it is still pretty limited compared to Excel Macros.
    Just found another article to read for you.
    http://www.cogniview.com/blog/spread...cel-vs-google/
    Last edited by MarvinP; 02-11-2016 at 01:08 PM.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ 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. Converting vba code into google spreadsheet script:dynamic dropdownlist
    By paradise2sr in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 03-05-2018, 11:00 PM
  2. How to enable Macro in Google Docs
    By jasond1992 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-20-2015, 11:33 PM
  3. Google Docs ()FILTER to Excel
    By royk2341 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-27-2015, 08:46 AM
  4. pull certain data from google docs form-produced spreadsheet to other docs
    By MisterCadillac in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 03-11-2014, 04:49 AM
  5. Converting spreadsheets from Microsoft Excel to Google Docs
    By hammerb in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 10-08-2013, 02:32 PM
  6. Uploading Excel Spreadsheet to Google Docs
    By Jakub in forum Excel General
    Replies: 0
    Last Post: 02-13-2012, 06:35 PM
  7. converting excel docs to word docs
    By rolercster in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 01-04-2005, 04:06 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