Changing sheet code name
I am trying to change the codename of a worksheet using the following code:
myWorkbook.VBProject.VBComponents(oldSheetName).Na me = NewCodeName
This works fine in excel 2000 but it fails in excel2003 - VBProject is no longer an object of a workbook.
How do I change the codename of a sheet in excel2003?