Backcolor value in hex

[Phil Hellmuth]

I want to get the hex value of a cell's backcolor, so I can replicate
the same color in Access. In VBA, I try to derive this by using
Hex(sheet.range(cell).interior.color). I get a hex value, but when I
try it in Access, it displays a different color. Am I grabbing the
correct property from the cell in Excel? Or, is there another way I can
derive the hex value?

Thanks in advance.

 

[Shane Devenshire]

What version of Excel/Access are you using 2003 or 2007?

I'm believe you can set the color using HSL or RGB scales, which apply to
both Excel and Access (at least in 2003).

 

[John]

HI Phil
Maybe this site can help, http://www.mvps.org/dmcritchie/excel/colors.htm
HTH
John