how to rename the existing excel sheet automatically

[ram712]

i need to create/add a copy of an excel sheet to an existing excel sheet consisting of table data so that the new excel sheet renamed automatically.
also, the new excel sheet should be blank but the previous formula restored.

[mzmishra]

This link may help you

http://www.xtremedotnettalk.com/showthread.php?t=74551

[tlhintoq]

Hello Ram,

Welcome to Bytes. I couldn't help but notice that all three of your posts are regarding an Excel project and that all three of your posts are in the form of "I need this ...."

Here at Bytes the volunteers don't write your code for you. You need to at least make an effort on your own first. The MSDN has an entire section just on the Office namespace, which includes a section for Excel

http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel(office.11).aspx

You will learn a lot more by first reading the documentation, and working with the sample code already provided by Microsoft. Then when you run into some issues with your code we can help you with the specifics.