Change color in excel from access

MichaÃ«l · Jan 28, 2009

Hello,

I'am trying from access to change the color of a cell in Excel, but it will
not succeed.

If ActiveCell.Interior.ColorIndex = 36 then
commands
End IF

When i do Msgbox ActiveCell.Interior.ColorIndex then i get allways the
value -4142.
What i'am doing wrong?

tx

MichaÃ«l

Alex Dybenko · Jan 28, 2009

Hi,
first you need to open excel sheet like here:
http://www.mvps.org/access/modules/mdl0006.htm

Then your code will look like:

If objXL.ActiveCell.Interior.ColorIndex = 36 then
....

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com