I'm using Office 2000. I have a fair number of exports from Access to Excel
every month. I'd *like* to format my spreadsheets the same, and automate as
much as possible (time permitting). (I would probably use vba on the Access
side, but don't really have the time right now to play with that.)

Can I use one or more macros to set the formatting properties? Such as what
text is in a header row cell, what my headers and footers are, what font, size,
gridlines, margins, etc.? Or do I still have to do all this manually?

If so, could you please give me an idea how? Or a website/location with
examples?

And would I want to store this/these macro(s) in a "personal.xls" workbook?

Thanks so much,

Tom