Keep same format in Excel when exporting

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

Guest

How can I keep the same format (report heading and page header) when I export
my Access reports to Excel?
 
As far as I know, it's not possible. If you want a particular format in
Excel, the choices are basically

1) write VBA code that exports the data (probably from a query rather
than a report) and then manipulates Excel to format the worksheets
exactly the way you want them.

2) create a pre-formatted workbook and use TransferSpreadsheet to export
data from a query into named ranges in the workbook. See
http://alexdyb.blogspot.com/2006/07/export-to-excel-range.html for
information on what's possible here.
 
Back
Top