[AccessD] Excel object model.

Ok, I found the numberformat property which will take care of the standard
number and percent formats.  Now I am still looking for the decimal places.

I am also looking for the property that will let me right justify text in a
cell.

Thanks,
Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bobby Heid
Sent: Thursday, December 30, 2004 7:55 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Excel object model.


Hi all,

I'm trying to format a small range of cells.  I want to set the format on a
row-by-row basis.  Basically, I am building a report from Access into an
Excel spreadsheet.

I am accessing the range like this

With .worksheets(1).Range(.worksheets(1).cells(l, 3),
.worksheets(1).cells(l, 5))
      End With 

Does anyone know what method(s)/properties I need to use to set the range's
number of decimals to display, as standard number, and as a percent?  I am
currently looking for this information, but if anyone already knows, it
would greatly speed up my work.

Thanks,
Bobby