Hi,

I would like to export tables, queries, subforms to Excel.
I've used the OutputTo function.
The problem is, I know nothing about formatting the worksheet from VBA. I would prefer to format the cells (Font size, font style, cell borders, colors ...).
Please help.
Thanks.

Search the forum this has been covered many times