Exporting Data to Excel

[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?

 

[Ken Snell [MVP]]

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).

 

[Ken Snell [MVP]]

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).