jeetendra_mitta
11 years agoOccasional Contributor
Adding new sheet in excel workbook.
Can someone post the code to adding any excel sheet in excel workbooks like sheet2, shet3 etc.
Set Excel = Sys.OleObject("Excel.Application")
set temp = Excel.Workbooks.Open("pathToYourWorkbook")
call temp.sheets.add()
temp.activesheet.name = "This is my new worksheet"
call temp.save