Create a Template from Existing Spreadsheet

  • Thread starter Thread starter Bill
  • Start date Start date
B

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.
 
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.
 
So should it pick the col widths, conditional formatting etc of the xls file
that it replaces?
 
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).
 
Back
Top