Create a Template from Existing Spreadsheet

[Bill]

Hi All,

Apologies for posting here but the 'templates' newsgroup doesn't appear to
be well used.

I have an existing spreadsheet that I create by exporting an Access query.
The column widths, page formatting, conditional formatting etc takes too
much time to do each time.

The spreadsheet I have right now is just about right though. From that
spreadsheet how do I create a template that I can then export my Access
query to please?

Regards.
Bill.

 

[Bob Phillips]

Just save it as a template file type, it is in the drop-down list if you do
a Save As.

A template is not necessary though, you could just save as a standard xls
and use that.

Or you could record the formatting options as a macro, and run the macro
each time.

Many ways to skin the cat.

 

[Bill]

So should it pick the col widths, conditional formatting etc of the xls file
that it replaces?

 

[Shane Devenshire]

Hi,

If you are exporting to Excel from access using the Office Links command I
don't believe you can indicate the target file, hense a template.
If you are exporting via the File, Export command again you can't pick a
template file but you can check the box Save Formatted.

Regarding a template: the idea here would be to take one of your completed
files and remove all the data keeping the necessary formatting. Then save
that file as a template file (xlt or xltx). Then when you export the Access
data, copy the result to the template file, (Paste Special, Values).