smile_please
04-21-2010, 11:34 PM
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
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