Styjun

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;

1

2

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

share|improve this question

edited Jul 9 '18 at 19:34

Community♦

111 silver badge

asked Jun 14 '16 at 3:24

Cheryl PerryCheryl Perry

611 silver badge33 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 | 

1

2

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

share|improve this question

edited Jul 9 '18 at 19:34

Community♦

111 silver badge

asked Jun 14 '16 at 3:24

Cheryl PerryCheryl Perry

611 silver badge33 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

share|improve this question

edited Jul 9 '18 at 19:34

Community♦

111 silver badge

asked Jun 14 '16 at 3:24

Cheryl PerryCheryl Perry

611 silver badge33 bronze badges

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

share|improve this question

edited Jul 9 '18 at 19:34

Community♦

111 silver badge

asked Jun 14 '16 at 3:24

Cheryl PerryCheryl Perry

611 silver badge33 bronze badges

share|improve this question

edited Jul 9 '18 at 19:34

Community♦

111 silver badge

asked Jun 14 '16 at 3:24

Cheryl PerryCheryl Perry

611 silver badge33 bronze badges

edited Jul 9 '18 at 19:34

Community♦

111 silver badge

edited Jul 9 '18 at 19:34

Community♦

111 silver badge

asked Jun 14 '16 at 3:24

Cheryl PerryCheryl Perry

611 silver badge33 bronze badges

asked Jun 14 '16 at 3:24

Cheryl PerryCheryl Perry

611 silver badge33 bronze badges

1 Answer
1

active

oldest

votes

0

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.

share|improve this answer

answered Jul 6 '16 at 12:56

miromiro

7122 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
);



);

draft saved

draft discarded

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

Name

Email

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

Name

Email

Required, but never shown

0

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.

share|improve this answer

answered Jul 6 '16 at 12:56

miromiro

7122 bronze badges

add a comment | 

0

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.

share|improve this answer

answered Jul 6 '16 at 12:56

miromiro

7122 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.

share|improve this answer

answered Jul 6 '16 at 12:56

miromiro

7122 bronze badges

share|improve this answer

answered Jul 6 '16 at 12:56

miromiro

7122 bronze badges

answered Jul 6 '16 at 12:56

miromiro

7122 bronze badges

answered Jul 6 '16 at 12:56

miromiro

7122 bronze badges