Can I format cells when outputting to excel?

S

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
 
Top