how to change the formula in each cell of an existing excel workbook

[ram712]

hi,

In sheet each cell is define with pre-defined formula. what i need is to change all the formulae in each cell when i create a copy of these existing worksheets.

[tlhintoq]

Sounds like good needs.
Please provide the relevant portion of your code where you are having troubles, along with any errors that are being thrown and we will try to help you fix your code.

[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/libr...ffice.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.