Do all of the formatting manually on the Excel spreadsheet with the macro
recorder turned on. You will then have your macro.

--
HTH

Bob Phillips

"Tom" wrote in message
...
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