[AccessD] Manipulating Excel Cells

Gustav Brock Gustav at cactus.dk
Wed Feb 1 11:01:46 CST 2006


Hi John

Example for background colour:

  Worksheets(1).Cells(11,21).Interior.ColorIndex = 15

Can be 0 for none or 1 to 56 for some basic colours.

/gustav

>>> Gustav at cactus.dk 01-02-2006 17:19:10 >>>
Hi John

No, that is not so ... why should it be that complicated?

To reference the value of a cell of a worksheet:

  .Worksheet.Cells(intRow, intColumn).Value = lngValue

and so on for all the other properties of a cell.

/gustav

>>> jwcolby at ColbyConsulting.com 01-02-2006 16:51:22 >>>

Does anyone have code for manipulating cells by cell(intRowNumbers, strColNames)?





More information about the AccessD mailing list