[AccessD] Creating New Spreadsheet with Automation

xlApp.worksheets(1).cells(l, i).numberformat = "#,###"

Or

xlApp.worksheets(1).cells(l, 13).numberformat = "0.00%"

Are the only 2 I have had to use.  Maybe that will help point you in the
right direction.

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin -
Beach Access Software
Sent: Friday, May 06, 2005 2:27 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Creating New Spreadsheet with Automation


Jim:

.Add.  That's it  Thanks.

Do you know offhand how to set a column to a specific format?  Text? Number?

Currency?  etc.

TIA

Rocky Smolin
Beach Access Software
http://www.e-z-mrp.com
858-259-4334