I have an Excel workbook that is composed of the results from Access queries.
IE. 1 query is 1 worksheet. So far I have 31 in the workbook and will likely
have 50-75 before I'm finished.
How can I populate the formatting from the 1st sheet (header naming
convention, size, layout, etc.) to each one that is there now and as I add
more? Each added sheet defaults back to the Excel 2000-2003 format.

Thanks

On Aug 27, 2:46 pm, amergerm35 <amerger...@discussions.microsoft.com>
wrote:
> I have an Excel workbook that is composed of the results from Access queries.
> IE. 1 query is 1 worksheet. So far I have 31 in the workbook and will likely
> have 50-75 before I'm finished.
> How can I populate the formatting from the 1st sheet (header naming
> convention, size, layout, etc.) to each one that is there now and as I add
> more? Each added sheet defaults back to the Excel 2000-2003 format.
>
> Thanks

Setup a template so each sheet will already be preformatted. You can
find instructions in Help under Templates. Would be an .xlt file.

To fix existing files, Select All, copy, goto all the other sheets you
want (Shift- or CTRL-click the tabs), goto cell A1, Paste
Special:Formats. You can do the same thing with a normal Paste if you
have to copy your actual column headers, assuming the data is always
in the exact same place.

You could also copy sheets (then delete the data) instead of using the
New:Sheet command. I generally Drag-n-Drop to do this, while holding
down CTRL. Unless the query process creates the sheet, then nevermind.

I don't know about that. When Access gives me the output from my query (which
all involve different data widths and colums, I then click on >Tools>Office
Links>Analyze with microsoft Excel. It opens a. Excel spreadsheet and I copy
the worksheet to the existing workbook, moving it to the back.
For every sheet I have to go in and change the formatting in about 5-6 areas.

Does this help clarify? I'm kind of new to using the output from one to
generate data in another application.

Amergerm

"Spiky" wrote:

> On Aug 27, 2:46 pm, amergerm35 <amerger...@discussions.microsoft.com>
> wrote:
> > I have an Excel workbook that is composed of the results from Access queries.
> > IE. 1 query is 1 worksheet. So far I have 31 in the workbook and will likely
> > have 50-75 before I'm finished.
> > How can I populate the formatting from the 1st sheet (header naming
> > convention, size, layout, etc.) to each one that is there now and as I add
> > more? Each added sheet defaults back to the Excel 2000-2003 format.
> >
> > Thanks
>
> Setup a template so each sheet will already be preformatted. You can
> find instructions in Help under Templates. Would be an .xlt file.
>
> To fix existing files, Select All, copy, goto all the other sheets you
> want (Shift- or CTRL-click the tabs), goto cell A1, Paste
> Special:Formats. You can do the same thing with a normal Paste if you
> have to copy your actual column headers, assuming the data is always
> in the exact same place.
>
> You could also copy sheets (then delete the data) instead of using the
> New:Sheet command. I generally Drag-n-Drop to do this, while holding
> down CTRL. Unless the query process creates the sheet, then nevermind.
>

I would think creating a normal template should help this, because
that works for new files. Unless the query makes its own formatting,
changing whatever Excel's normal format is, then there probably isn't
much you can do ahead of time.

Since you are copying the data in, you could try Paste Special and
select plain Text from the dialog box. It isn't the same as the normal
Excel Paste Special when copying from a different program, but it is
there.

Copy one of your formatted sheets to a new book. File/Save As "Sheet.xlt"
(file type template). This automatically opens your template folder, but you
need to locate your XLSTART folder and put this file in it. When you create a
new sheet, it should pull from this template.

"Spiky" wrote:

> On Aug 27, 2:46 pm, amergerm35 <amerger...@discussions.microsoft.com>
> wrote:
> > I have an Excel workbook that is composed of the results from Access queries.
> > IE. 1 query is 1 worksheet. So far I have 31 in the workbook and will likely
> > have 50-75 before I'm finished.
> > How can I populate the formatting from the 1st sheet (header naming
> > convention, size, layout, etc.) to each one that is there now and as I add
> > more? Each added sheet defaults back to the Excel 2000-2003 format.
> >
> > Thanks
>
> Setup a template so each sheet will already be preformatted. You can
> find instructions in Help under Templates. Would be an .xlt file.
>
> To fix existing files, Select All, copy, goto all the other sheets you
> want (Shift- or CTRL-click the tabs), goto cell A1, Paste
> Special:Formats. You can do the same thing with a normal Paste if you
> have to copy your actual column headers, assuming the data is always
> in the exact same place.
>
> You could also copy sheets (then delete the data) instead of using the
> New:Sheet command. I generally Drag-n-Drop to do this, while holding
> down CTRL. Unless the query process creates the sheet, then nevermind.
>

I tried both of these and no success. I'm going to try writing some VB code
for Access and try to force it that way.

Thanks,
Bill

"Valerie" wrote:

> Copy one of your formatted sheets to a new book. File/Save As "Sheet.xlt"
> (file type template). This automatically opens your template folder, but you
> need to locate your XLSTART folder and put this file in it. When you create a
> new sheet, it should pull from this template.
>
> "Spiky" wrote:
>
> > On Aug 27, 2:46 pm, amergerm35 <amerger...@discussions.microsoft.com>
> > wrote:
> > > I have an Excel workbook that is composed of the results from Access queries.
> > > IE. 1 query is 1 worksheet. So far I have 31 in the workbook and will likely
> > > have 50-75 before I'm finished.
> > > How can I populate the formatting from the 1st sheet (header naming
> > > convention, size, layout, etc.) to each one that is there now and as I add
> > > more? Each added sheet defaults back to the Excel 2000-2003 format.
> > >
> > > Thanks
> >
> > Setup a template so each sheet will already be preformatted. You can
> > find instructions in Help under Templates. Would be an .xlt file.
> >
> > To fix existing files, Select All, copy, goto all the other sheets you
> > want (Shift- or CTRL-click the tabs), goto cell A1, Paste
> > Special:Formats. You can do the same thing with a normal Paste if you
> > have to copy your actual column headers, assuming the data is always
> > in the exact same place.
> >
> > You could also copy sheets (then delete the data) instead of using the
> > New:Sheet command. I generally Drag-n-Drop to do this, while holding
> > down CTRL. Unless the query process creates the sheet, then nevermind.
> >