Format XL Book from Access

  • Thread starter Thread starter Greg Franke
  • Start date Start date
G

Greg Franke

I have an Access App. that exports data to an excel spreadsheet. I want to
be able to format rows & columns from access after the export. I have tried
recording a macro in XL and pasting to access and reformatting it. I just
can't seem to get the row & column formatting to work.

I want to be able to select the first row and center,bold, and underline

Select the last two columns of data and apply conditional formatting.

Anyone have any examples of how this can be done with access "controlling"
XL?

Thanks!
 
Back
Top