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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export Data from Report or Query to Excel 1
Keeping format when exporting to excel 1
Export Access Report to Excel keep format 4
Exporting to Excel 2007 1
Hold format when exporting 1
Exporting pivot tables 2
Export Access Report to Excel 4
Export from Access 2007 Report to excel 3

Back
Top