Can I format cells when outputting to excel?

[Stapes]

Hi

I am making an excel report from access using the following:


DoCmd.TransferSpreadsheet acExport, _
acSpreadsheetTypeExcel9, "QUERY NAME", _
"C:\FILE LOCATION AND NAME - " & sToday & ".xls", True, "SHEET NAME"


Is there any way I can format the cells in excel from here. I am
thinking background colours, and number / date formats?


Stapes

 

[Douglas J. Steele]

Your only option is to use Excel Automation.

See whether my July, 2005 "Access Answers" column in Pinnacle Publication's
"Smart Access" is enough to get you going. You can download the column (and
sample database) for free at
http://www.accessmvp.com/djsteele/smartaccess.html