ExcelBanter - Automating Excel with Java Script

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Automating Excel with Java Script (https://www.excelbanter.com/excel-programming/284018-automating-excel-java-script.html)

Jim Hudson

Automating Excel with Java Script

I'm trying to write some client-side functions to populate an Excel template. Everything works except for the Worksheet.Copy() method. I cannot find an example in JavaScript. Do you know how to convert the following line of VBA code to JavaScript

Worksheets(1).Copy after:=Worksheets(ThisWorkbook.Worksheets.Count

Thanks

All times are GMT +1. The time now is 01:22 PM.