How to convert VBA into Javascript in order to upload Excel Macro-enable workbook on Google Drive?How to convert decimal to hexadecimal in JavaScriptHow can I convert a string to boolean in JavaScript?How to avoid using Select in Excel VBArun-time error '13': type mismatch VBA 2010 to ensure uppercase text in cellExcel workbook created using VBA does not contain macrosRun Excel VBA sub from javascript in a secure environmentSaving new Excel document as macro-free workbook without promptWith Excel 2016, VBA will not activate an alternate worksheet when the Macro is associated with a worksheetExcel VBA Inserting Worksheet_Change Code Into Multiple WorksheetsColour a cell if a certain number is entered
Job offer without any details but asking me to withdraw other applications - is it normal?
How should we understand "unobscured by flying friends" in this context?
What is negative current?
Creating a Master Image to roll out to 30 new Machines Licensing Issues
Change-due function
2.5 year old daughter refuses to take medicine
Are there any space probes or landers which regained communication after being lost?
How can I protect myself in case of a human attack like the murders of the hikers Jespersen and Ueland in Morocco?
Is there a "right" way to interpret a novel? If so, how do we make sure our novel is interpreted correctly?
Why should I always enable compiler warnings?
What happens to gadgets of players that leave a match
On the origin of "casa"
Procedure for traffic not in sight
Two different colors in an Illustrator stroke / line
Why are some Mac apps not available on AppStore?
How to make your response cachable by browser?
How accurate is the new appraisal system?
Is BitLocker useful in the case of stolen laptop?
Is there any detail about ambulances in Star Wars?
How do I politely hint customers to leave my store, without pretending to need leave store myself?
Which ping implementation is cygwin using?
How to create a list of dictionaries from a dictionary with lists of different lengths
Was Robin Hood's point of view ethically sound?
Gas pipes - why does gas burn "outwards?"
How to convert VBA into Javascript in order to upload Excel Macro-enable workbook on Google Drive?
How to convert decimal to hexadecimal in JavaScriptHow can I convert a string to boolean in JavaScript?How to avoid using Select in Excel VBArun-time error '13': type mismatch VBA 2010 to ensure uppercase text in cellExcel workbook created using VBA does not contain macrosRun Excel VBA sub from javascript in a secure environmentSaving new Excel document as macro-free workbook without promptWith Excel 2016, VBA will not activate an alternate worksheet when the Macro is associated with a worksheetExcel VBA Inserting Worksheet_Change Code Into Multiple WorksheetsColour a cell if a certain number is entered
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I would like to upload an Excel Macro-enable workbook on Google Drive but Google didn't support this file. They suggest me that I should convert VBA into Javascript and use Script Editỏ. I would like to convert this functionality in javascript, but I don't know where it is wrong. Can you give me a help?
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("A2:A100")) Is Nothing Then
With Target(1, 2)
.Value = Date
.EntireColumn.AutoFit
End With
End If
End Sub
Javascript conversion attempt: 1
javascript excel-vba google-drive-api vba excel
edited Jul 9 '18 at 19:34
Community♦
11 silver badge
asked Jun 14 '16 at 3:24
Cheryl PerryCheryl Perry
61 silver badge3 bronze badges
add a comment |
I would like to upload an Excel Macro-enable workbook on Google Drive but Google didn't support this file. They suggest me that I should convert VBA into Javascript and use Script Editỏ. I would like to convert this functionality in javascript, but I don't know where it is wrong. Can you give me a help?
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("A2:A100")) Is Nothing Then
With Target(1, 2)
.Value = Date
.EntireColumn.AutoFit
End With
End If
End Sub
Javascript conversion attempt: 1
javascript excel-vba google-drive-api vba excel
edited Jul 9 '18 at 19:34
Community♦
11 silver badge
asked Jun 14 '16 at 3:24
Cheryl PerryCheryl Perry
61 silver badge3 bronze badges
It will be more helpful if you paste your attempt at converting to JS in the question body
– Joe Niland
Jun 14 '16 at 5:14
add a comment |
I would like to upload an Excel Macro-enable workbook on Google Drive but Google didn't support this file. They suggest me that I should convert VBA into Javascript and use Script Editỏ. I would like to convert this functionality in javascript, but I don't know where it is wrong. Can you give me a help?
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("A2:A100")) Is Nothing Then
With Target(1, 2)
.Value = Date
.EntireColumn.AutoFit
End With
End If
End Sub
Javascript conversion attempt: 1
javascript excel-vba google-drive-api vba excel
edited Jul 9 '18 at 19:34
Community♦
11 silver badge
asked Jun 14 '16 at 3:24
Cheryl PerryCheryl Perry
61 silver badge3 bronze badges
I would like to upload an Excel Macro-enable workbook on Google Drive but Google didn't support this file. They suggest me that I should convert VBA into Javascript and use Script Editỏ. I would like to convert this functionality in javascript, but I don't know where it is wrong. Can you give me a help?
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("A2:A100")) Is Nothing Then
With Target(1, 2)
.Value = Date
.EntireColumn.AutoFit
End With
End If
End Sub
Javascript conversion attempt: 1
javascript excel-vba google-drive-api vba excel
javascript excel-vba google-drive-api vba excel
edited Jul 9 '18 at 19:34
Community♦
11 silver badge
asked Jun 14 '16 at 3:24
Cheryl PerryCheryl Perry
61 silver badge3 bronze badges
edited Jul 9 '18 at 19:34
Community♦
11 silver badge
asked Jun 14 '16 at 3:24
Cheryl PerryCheryl Perry
61 silver badge3 bronze badges
edited Jul 9 '18 at 19:34
Community♦
11 silver badge
edited Jul 9 '18 at 19:34
Community♦
11 silver badge
edited Jul 9 '18 at 19:34
Community♦
11 silver badge
11 silver badge
asked Jun 14 '16 at 3:24
Cheryl PerryCheryl Perry
61 silver badge3 bronze badges
asked Jun 14 '16 at 3:24
Cheryl PerryCheryl Perry
61 silver badge3 bronze badges
asked Jun 14 '16 at 3:24
Cheryl PerryCheryl Perry
61 silver badge3 bronze badges
61 silver badge3 bronze badges
It will be more helpful if you paste your attempt at converting to JS in the question body
– Joe Niland
Jun 14 '16 at 5:14
add a comment |
It will be more helpful if you paste your attempt at converting to JS in the question body
– Joe Niland
Jun 14 '16 at 5:14
It will be more helpful if you paste your attempt at converting to JS in the question body
– Joe Niland
Jun 14 '16 at 5:14
It will be more helpful if you paste your attempt at converting to JS in the question body
– Joe Niland
Jun 14 '16 at 5:14
add a comment |
1 Answer
1
active
oldest
votes
If you do not want to rewrite all the code, look for GSpread.NET. VBA and GSpread.NET work with Google Spreadsheets by using API from Microsoft Excel.
Need replace CreateObject(Excel.Application) to
Set objExcel = CreateObject("GSpreadCOM.Application")
app.MailLogon(Name, ClientIdAndSecret, ScriptId);
and work with Google Spreadsheets as normal Microsoft Excel documents.
answered Jul 6 '16 at 12:56
miromiro
712 bronze badges
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/4.0/"u003ecc by-sa 4.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f37802448%2fhow-to-convert-vba-into-javascript-in-order-to-upload-excel-macro-enable-workboo%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
If you do not want to rewrite all the code, look for GSpread.NET. VBA and GSpread.NET work with Google Spreadsheets by using API from Microsoft Excel.
Need replace CreateObject(Excel.Application) to
Set objExcel = CreateObject("GSpreadCOM.Application")
app.MailLogon(Name, ClientIdAndSecret, ScriptId);
and work with Google Spreadsheets as normal Microsoft Excel documents.
answered Jul 6 '16 at 12:56
miromiro
712 bronze badges
add a comment |
If you do not want to rewrite all the code, look for GSpread.NET. VBA and GSpread.NET work with Google Spreadsheets by using API from Microsoft Excel.
Need replace CreateObject(Excel.Application) to
Set objExcel = CreateObject("GSpreadCOM.Application")
app.MailLogon(Name, ClientIdAndSecret, ScriptId);
and work with Google Spreadsheets as normal Microsoft Excel documents.
answered Jul 6 '16 at 12:56
miromiro
712 bronze badges
add a comment |
If you do not want to rewrite all the code, look for GSpread.NET. VBA and GSpread.NET work with Google Spreadsheets by using API from Microsoft Excel.
Need replace CreateObject(Excel.Application) to
Set objExcel = CreateObject("GSpreadCOM.Application")
app.MailLogon(Name, ClientIdAndSecret, ScriptId);
and work with Google Spreadsheets as normal Microsoft Excel documents.
answered Jul 6 '16 at 12:56
miromiro
712 bronze badges
If you do not want to rewrite all the code, look for GSpread.NET. VBA and GSpread.NET work with Google Spreadsheets by using API from Microsoft Excel.
Need replace CreateObject(Excel.Application) to
Set objExcel = CreateObject("GSpreadCOM.Application")
app.MailLogon(Name, ClientIdAndSecret, ScriptId);
and work with Google Spreadsheets as normal Microsoft Excel documents.
answered Jul 6 '16 at 12:56
miromiro
712 bronze badges
answered Jul 6 '16 at 12:56
miromiro
712 bronze badges
answered Jul 6 '16 at 12:56
miromiro
712 bronze badges
answered Jul 6 '16 at 12:56
miromiro
712 bronze badges
712 bronze badges
add a comment |
add a comment |
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f37802448%2fhow-to-convert-vba-into-javascript-in-order-to-upload-excel-macro-enable-workboo%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
It will be more helpful if you paste your attempt at converting to JS in the question body
– Joe Niland
Jun 14 '16 at 5:14