Reading a cell in Excel?

[HenryW]

I need to interrogate the results of a formula generated earlier on the same row.

What is the format to check a specific cell? DId enough experimentation and have had no luck at the specifics.

If formula generates say 200.00 in cell "A3"...

if chWorkSheet:???? = 200 then....

Can someone help me fill in ???

Thanks

 

[AndrewSmith]

Try:

IF chWorkSheet:Cells(3,1):VALUE = "200" THEN....

You may need to cast the value around into decimal variables for your purposes.

 

[HenryW]

I am assuming Cells (3,1) is Looking at the 3rd row and first column??


I tried that and get weird numbers which I am not sure have any relationship as it point to variety of cells and the same number shows up.

MESSAGE
chWorkSheet:Cells(14,1) skip
chWorkSheet:Cells(15,1) skip
chWorkSheet:Cells(16,1) skip
chWorkSheet:Cells(17,1) skip
chWorkSheet:Cells(18,1) skip
chWorkSheet:Cells(19,1) skip
chWorkSheet:Cells(20,1) skip
VIEW-AS ALERT-BOX.

3652828 ???
3652828 ???
3652828 ???
3652828 ???
3652828 ???
3652828 ???
3652828 ???

Not sure what to do with these. They all pointing to different values and give the same number.

ANy other hints?

 

[zee]

You did not include :VALUE, according to the previous suggestion. Try this:

MESSAGE
chWorkSheet:Cells(14,1):VALUE skip
chWorkSheet:Cells(15,1):VALUE skip
chWorkSheet:Cells(16,1):VALUE skip
chWorkSheet:Cells(17,1):VALUE skip
chWorkSheet:Cells(18,1):VALUE skip
chWorkSheet:Cells(19,1):VALUE skip
chWorkSheet:Cells(20,1):VALUE skip
VIEW-AS ALERT-BOX.

 

[HenryW]

Thanks ... That's perfect...

Been a long day missed that on the original reply.

It works perfectly.

I will add that to my growing list of interactions to Excel from Progress.

Henry