Forum Discussion

jeetendra_mitta's avatar
jeetendra_mitta
Occasional Contributor
10 years ago
Solved

Adding new sheet in excel workbook.

Can someone post the code to adding any excel sheet in excel workbooks like sheet2, shet3 etc.
  • jmcpeek's avatar
    jmcpeek
    10 years ago


    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

1 Reply

Sort By
  • jmcpeek's avatar
    jmcpeek
    Contributor
    10 years ago


    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