Now I wants to have me cake & eat it

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