Excel Reports

[Bschmale]

Hello everyone,

So this isn't as much of an access question but an excel question.

I just took over the responsibility of sending daily reports to our customers from an established DB that runs our field operations. Currently, I run a query and I export this into excel where I do a few calculations. I am then having to reformat the top row each time (wrap text, adjust column width, bold etc). I was wondering if there was a way to do this formatting automatically? It doesn't take too much time but when I factor in having to do this everyday the time adds up.

Right now I am keeping a separate workbook open that is already formatted, copying the top row, and then using "Alt + ES" twice to copy formatting and column widths. Any help speeding this up would be great.

Thanks!

[June7]

This would require VBA code that opens and manipulates Excel objects.

[Bschmale]

Gotcha.

Thanks for the reply. I guess for now I will stick with the method I am using now.