Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieve value using vb6 from an excel workbook - precision question
Hi All
I have a Vb6 app from which I am retreiving a value in a cell in a worksheet in a workbook. The code goes something like this: SomeLabel.caption = MyCells(rownum,colnum).value Looking directly at the cell in the workbook, I see a value of 3. However when I debug.print or msgbox MyCells(rownum,colnum).value from the vb6 app, I find that the value is actually more like 2.9999889889 or something similar. Whether I format the cell in the workbook as a number to 0 decimal places, or as General, makes no difference. I conclude from this that the vb6 code is actuall retrieving the excel *stored* value rather than the excel *presented* value. Is this correct? How do I retrieve the value "3" rather than the entire floating point value? Or is the only way to coerce the data type in the vb6 app using a ceiling like function or declaring a variable as type integer and assigning it? Any help appreciated. Regards Andrew |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
RETRIEVE DATA FROM ANOTHER WORKBOOK BY CHECKING ON WORKBOOK DATE | Excel Worksheet Functions | |||
Retrieve Excel Workbook | Excel Worksheet Functions | |||
Precision displayed does not match precision in cell | Excel Discussion (Misc queries) | |||
programatically retrieve selected rows from excel workbook | Excel Programming | |||
precision question | Excel Programming |