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
Bookmarks