Excel templates and transferspreadsheet method

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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.
 
Back
Top