Hi,

I have a cell where a formula is defined. Formula works fine and I see "Y" in this cell.

So I would like to get this "Y" in my VEE application.

When trying to retrieve(using xLIB.DataFromCell) a data from cell I am getting the formula(e.g =IF(A1=1,"Y","N")).

How I can get my data?

Thanks.

I have a cell where a formula is defined. Formula works fine and I see "Y" in this cell.

So I would like to get this "Y" in my VEE application.

When trying to retrieve(using xLIB.DataFromCell) a data from cell I am getting the formula(e.g =IF(A1=1,"Y","N")).

How I can get my data?

Thanks.

xlLib.EvalCellFormulainstead of xLIB.DataFromCell.The object is located at Excel>GetData>Evalate Cell Data.

Hope it's work for you.