We are building a new experience for our SmartBear Community.
This site is now read-only. You can still browse and search as usual. Learn More

Forum Discussion

jeetendra_mitta's avatar
jeetendra_mitta
Occasional Contributor
12 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
    12 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

  • jmcpeek's avatar
    jmcpeek
    Frequent Contributor
    12 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