Excel templates and transferspreadsheet method

[Guest]

Hey!

When does an excel template get applied to a spreadsheet created by the
TransferSpreadsheet method?

I am mass exporting Access data into regionalized spreadsheets for
distribution and need to apply formatting and a variety of cell formulas to
the exported data - any suggestions other than writing a macro and running it
on each spreadsheet?

Thank you for everything!

 

[John Nurick]

No templates, alas: you'll need to write Access VBA code to automate
Excel. Something along these lines may well be less trouble than using
TransferSpreadsheet first and formatting the workbook afterwards:

-Launch an instance of Excel
-Create a new workbook from your xlt template
-Open a recordset on your data
-Use Excel's Range.CopyFromRecordset to place the data where you need it
-Do any remaining formatting that's needed.

 

[Guest]

That is what I was afraid of.

Thank you!

Patrick