Exporting data

S

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
 
K

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.
 
Top