Get Cell Calculated Value

Jan 24, 2012 at 11:46 AM


If a Cell has a CellFormula assigned, is there any way to get the calculated value of the formula? Since Excel is using its own calculating mechanism, it is done on the fly, so I was wondering if there is any other way to get the calculated value, except for running COM object excel, and open the document?