macro for formatting

[Tom]

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

 

[Bob Phillips]

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

 

[Tom]

This is *really* cool. Thanks!

I've put my macro code into "personal.xls". (I first tried "personal.xlt".)
Neither works (can't find it) when my 'personal.???' is in 'XLSTART'. When it's
in the same directory as the spreadsheet I'm working on however, it works just
fine. Any idea what I might be doing wrong?

Appreciate the help,

Thanks again.

 

[Bob Phillips]

Put Personal.xls in the XLStart directory, shutdown Excel, then start it
again and you should have macros from Personal.xls in the macros list. It
will say something like

Personal.xls!myMacro