hey,
Thanks for the reply, But I can not use above method bcoz I can not copy data to new sheet (copy paste has some issue with my excel). only way to rename tab.
I found this code for rename but getting below error,
Dim ws as Object = GetWorksheet(handle,workbookname,oldworksheetname,neworksheetname)
ws.Set=oldworksheetname
ws.Name=neworksheetname
Internal : Could not execute code stage because exception thrown by code stage: Conversion from string "newsheetname" to type 'Boolean' is not valid.
if any one can help me what I am missing any above code. I am really not good at vb.
Thanks,Nitin