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 ToolsOffice
LinksAnalyze 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
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.