[AccessD] Manipulating Excel Cells

Gustav Brock Gustav at cactus.dk
Wed Feb 1 11:26:06 CST 2006


Hi John

That can be done.
So your problem is solved?

/gustav

>>> jwcolby at ColbyConsulting.com 01-02-2006 18:02:30 >>>
Gustav, Jim,

Nope, what I was looking for was

.Range(strRange).Interior.ColorIndex = rst!DS_ExcelColorIndex

In this case at least, strRange can be in the form "B23", referencing column B, row 23.





More information about the AccessD mailing list