Need help converting my VBA code to Google Script [duplicate]

Question

This is regarding the following VBA:

Public Sub NewSheet()

   ActiveSheet.Copy after:=Worksheets(Worksheets.Count)
   Worksheets(Worksheets.Count).Name = Format(Date, "m.d.yy")
   Worksheets(Worksheets.Count).Range("A1") = Date
   Worksheets(Worksheets.Count - 1).Visible = xlSheetHidden

End Sub

I have been using this VBA in excel to help duplicate sheets and hide sheets dynamically. But we have decided to use Google Sheets because it is more iOS friendly and it is easier to use across multiple users.

Now I am at a loss as to how to use (convert) this VBA code to Google Script. Any help would be appreciated.

_/ \ _

Please start by reading developers.google.com/apps-script/guides/sheets then checkout How to Ask. — Wicket
– Wicket, Commented Oct 20, 2021 at 23:04

Yuri Khristich · Accepted Answer · 2021-10-20 23:46:02Z

3

Probably it can be done about this way:

function myFunction() {
  var ss        = SpreadsheetApp.getActiveSpreadsheet(); // current spreadsheet
  var old_sheet = ss.getActiveSheet();                   // current (old) sheet
  var new_sheet = old_sheet.copyTo(ss);                  // make a copy

  new_sheet.setName(Utilities.formatDate(new Date(), 'GMT', 'MM.dd.yy')); // set the name
  new_sheet.getRange('A1').setValue(new Date());         // set the cell A1
  old_sheet.hideSheet();                                 // hide the old sheet
}

answered Oct 20, 2021 at 23:46

Yuri Khristich

14.6k3 gold badges11 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Need help converting my VBA code to Google Script [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related