Exporting data

[Shirley]

I am also exporting the data from Access to Excel format.
How can format the excel in my VBA--for example, I want
the first row to be bold, and some columns to be bold or
with different color?

Thanks very much!

Shirley

 

[Ken Snell]

You must use Automation (VBA code that opens the EXCEL file and then
manipulates it via EXCEL VBA actions).

No way to do this in the export command itself.