Excel automation

giulio.cipo
giulio.cipo Member Posts: 77
edited 2004-02-13 in Navision Attain
Hi,

i'm working with excel automation and i should format a cell.
i have already done this without problem but now i shoul change color of cell depends of sign.

I used this code but in run time the sistem retun me an error :

Sheet.range(....).numberformat := '###0,00;[Red]###0,00';

the error is : impossible define the numbert format property for Class range.

I'm working with italian version and i'm coping code from excel macro but it doesn't work.

some have already solved this problem?
thanks

Comments

  • Christian_Buehl
    Christian_Buehl Member Posts: 145
    swap dot and comma

    ....numberformat('###0.00;[Red]###0.00')
    and it should work.
    The Interface is using the US-English style for Number fomatting. They use dots instead of comma and vice versa.

Categories