getting excel formulated cells value

Hi,

I'm going crazy trying to figure out how do i get the calculated value in one of the cells in excel spreadsheet to work.

example, I have a cell that has the formula =sum(c1,c3), c1 = 1, c3 = 4

so result will be 5 in whatever cell that i set the formula in.

I've gone bonkers once i try to open the excel file and tried to get that value.

Any help would be appreciated.

Hi,

I've gone bonkers once i try to open the excel file and tried to get that value.

Get that formula value from where exactly? VBA code?

I have create an application where i'm suppose to generate a excel accounts report for the accounts dept. using their excel spreadsheet template, i'm suppose to map values to the excel spreadsheet template and the excel template will calculate the suppose value with the formula like =SUM(C1,C2,C3....) in this "total" cell, i found out that i'm able to get other cells value but not this "formulated" cell. Please show me how i can actually get that value?

Thank you sir!

Hi,

You should be able to get the value of that cell in exactly the same way, using Range.Value. Please post the code you tried?