Exporting data

  • Thread starter Thread starter Shirley
  • Start date Start date
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
 
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.
 
Back
Top