Le 2005-03-03 14:22, Sevastian `seva` Foglia a écrit :
This is my code

.....
Dim oCell as Object
Dim sVal as String
oCell = oCells.getCellByPosition(0, 0)
sVal = oCell.string
oCell.value = CDbl(sVal)
.....

Value on cell is <'0,30>.


With your code and your cell content I get a runtime error from CDbl : "Incompatible data types". This is normal because the string does not represent a number. You should remove the apostrophe.
If you don't get a runtime error then you have somewhere an instruction On Error Resume Next. Of course the result of CDbl is undefined in case of error.


   Bernard



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to