[AccessD] Excel Automation ... Setting Default Formatting In Excel

Hi:

I have a fairly complex Access to Excel automation project, and having
conquered my named ranges issue, I'm wondering about the best way to set
default formatting for columns (percentages, decimals, conditional formats).

The application dynamically creates worksheets in the Excel workbook
(sometimes it has 5 worksheets, sometimes more) from data stored in Access. 

The data will always be in the same columns, (EX: column M is percent,
Column N is 2 decimals, etc.); Can I have Excel set defaults for these
columns before exporting/creating the data, or is it better to just do this
in VBA?

Thanks in advance.

Larry Mrazek
LCM Research, Inc.
www.lcm-res.com
lmrazek at lcm-res.com
ph. 314.432.5886
fx. 314.432.3304