Hi All,

I have an Excel file (For Eg; I have C:\Test.xlsx), In this file i need to insert a new sheet and save it.

Im able to insert a new sheet and save it, but when i open manually, the sheets are hidden. I need to goto View-> Unhide to view the sheets..

Is there any script to add a new sheet and it should be able to view when i open the file.

The script i used is:

Set C_WorkBook = GetObject("C:\Test.xlsx")
Set C_WorkSheet = C_WorkBook.Worksheets.Add
C_WorkSheet.Name = "ABC"
C_WorkBook.save
C_WorkBook.close


Thanks in Advance,
Bala