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

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

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.

On Mon, 20 Jun 2005 18:29:42 +0100, "Bob Phillips"
wrote:

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

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

--
HTH

Bob Phillips

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

On Mon, 20 Jun 2005 18:29:42 +0100, "Bob Phillips"

wrote:

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