Hex values in a data variable

[SiteMaze]

I am using the Excel_Com UDF to change the colour of a cell.

$tmp_str_BinColour = 0xFFFFFF

_ExcelCellColorSet($oExcel, 45, 17, 45, 17, 256, $tmp_str_BinColour)

The above code works but how do I store Hex values in a variable?

I have the colour stored in a database. So when I retreive it is in string type. And it doesn't work.

$tmp_str_BinColour = "0xFFFFFF"

_ExcelCellColorSet($oExcel, 45, 17, 45, 17, 256, $tmp_str_BinColour)

[ProgAndy]

Try to use: $tmp_str_BinColour = Binary("0xFFFFFF")

[SiteMaze]

Try to use: $tmp_str_BinColour = Binary("0xFFFFFF")

It is not working. "Failure with the excel object" error.

[ProgAndy]

Try StringToBinary("0xFFFFFF")

or Execute("0xFFFFFF")

[SiteMaze]

Thanks. Execute("0xFFFFFF") worked.

[SiteMaze]

Sorry, I was too fast to jump the train.

Execute("0xFF0000") returns 16711680 which is blue colour, and not red.

[Malkey]

Sorry, I was too fast to jump the train.

Execute("0xFF0000") returns 16711680 which is blue colour, and not red.

I am guessing here.

If "0xFF0000" returns blue, the BGR colour scheme could be in use.

If "0x0000FF" returns Red then the BGR color scheme is being used. As opposed to the RGB color scheme.

[SiteMaze]

I am guessing here.

If "0xFF0000" returns blue, the BGR colour scheme could be in use.

If "0x0000FF" returns Red then the BGR color scheme is being used. As opposed to the RGB color scheme.

LOL, you are correct. Just didn't suspect AutoIT will be using the BGR code. I thought it was more to do with the datatype thingy.

So now I had to convert the RGB from my database to BGR and then run through 'execute'. Work great!