[AccessD] Manipulating Excel Cells

>So your problem is solved?

Uhhhh yep. 


John W. Colby
www.ColbyConsulting.com 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Wednesday, February 01, 2006 12:26 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Manipulating Excel Cells

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.


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com