Exporting Data to Excel

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

I am exporting data to excel and would like to automatically name the ranges
in excel to correspond to field names in Access. Is there an easy way to do
this?
 
Exporting using Range is a process that can have difficulties. See this
article:

Using the Range Argument of TransferSpreadsheet when Exporting Data to an
EXCEL File (VBA)
http://www.accessmvp.com/KDSnell/EXCEL_Export.htm#ExpRange

The code examples on the above page will show you how to do the export. The
examples do not include the use of the undocumented Range argument (it would
be added as the last argument for TransferSpreadsheet).
 
Exporting using Range is a process that can have difficulties. See this
article:

Using the Range Argument of TransferSpreadsheet when Exporting Data to an
EXCEL File (VBA)
http://www.accessmvp.com/KDSnell/EXCEL_Export.htm#ExpRange

The code examples on the above page will show you how to do the export. The
examples do not include the use of the undocumented Range argument (it would
be added as the last argument for TransferSpreadsheet).
 
Back
Top