473,473 Members | 1,807 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

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

4 New Member
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.
Jan 21 '10 #1
2 1801
tlhintoq
3,525 Recognized Expert Specialist
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.
Jan 21 '10 #2
tlhintoq
3,525 Recognized Expert Specialist
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.
Jan 21 '10 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Dixie | last post by:
I wish basically to put the following formula into cell L6 in an excel spreadsheet.=COUNTIF(L6:L1025,"Yes"). I have tried the following code and it wont compile. the colon : is unacceptable....
4
by: adrian | last post by:
hello! i am using visual studio 2000 and am trying to insert a formúla into an excel cell. the code goes like this: with excel .workbooks.open (datei(i)) .activesheet.name ="statistik 2004"...
1
by: gssstuff | last post by:
Hi I have a need to send data from Access to an existing Excel template that I am using for reporting purposes. The nature of the data in the Access data table does not lend itself to a simple...
5
by: Elena | last post by:
I need the VB.NET code to change the header/footer of an Excel spread sheet, ASAP. I am doing it through a VB application. I can change the ranges/cell values using code, but I do not know how to...
3
by: nagen | last post by:
I have an existing excel file & i would like to enter a specific value at cell A1 in Excel2003 using asp.net 2.0 how can i do this?
5
by: hmiller | last post by:
Hey there folks: I have been trying to get this work for about a week now. I'm new to VBA... I am trying to transfer a populated table in Access to an existing, but blank, Excel worksheet. I...
3
by: prakashsakthivel | last post by:
Hi Members, What I want to know is, I want to detect formula which cells has formula and converted as text. let us example, One excel workbook have 4 sheet. all cells of each sheet contains...
3
by: ShadowLocke | last post by:
Ok, Im having some troubles fully grasping XSL. Its hard to explain with out showing so first..this is what i have so far. <xsl:stylesheet version='1.0' ...
1
by: Monusonu | last post by:
Hi Expert, I am trying to get the value from excel formula cell using POI. My code works fine for less complex formula cells, but fails or returns error code for complex formula cells. Following...
3
by: somsub | last post by:
Hi, I m facing a problem to add an array as a comment to a MS excel cell using Spreadsheet :: WriteExcel . I m using the below code use Spreadsheet::WriteExcel; $workbook =...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.