Format different worksheets automatically

[mariopayan]

I have a Microsoft Access database that creates an Excel spreadsheet
with multiple worksheets. Then mails it to certain people. This is on
a daily basis.

What I want is to make the worksheets of the file to be formatted a
certain way, each differently.

For example, I want to insert certain given rows for a Title and Column
names. But also change the font, size and borders of the cells
containing the data (data exported from Access).

Is there any hope on doing this automatically?

Thanks in advance.


Mario

 

[Mario]

Or maybe I can just insert the data to an existing Excel worksheet that
already has the first four rows that I need to keep unchanged ( thses
rows would have a logo and some other static info ).

Tks


Mario