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.
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.
anyone have ideas?
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.
Originally Posted by shg
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:
Just found another article to read for you.You can accomplish a lot of tasks with Google Apps Script but it is still pretty limited compared to Excel Macros.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks