[AccessD] Excel object model.

Bobby Heid bheid at appdevgrp.com
Thu Dec 30 06:54:41 CST 2004


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


More information about the AccessD mailing list