http://www.accessmvp.com/KDSnell/EXCEL_Export.htm#CreateExportParam - Create and Export a Parameter Query to EXCEL file via TransferSpreadsheet (VBA)
http://www.accessmvp.com/KDSnell/EXCEL_Export.htm#FilterExportSepFiles - Create a Query and Export multiple "filtered" versions of a Query (based on data in another table) to separate EXCEL files via TransferSpreadsheet (VBA)
http://www.accessmvp.com/KDSnell/EXCEL_Export.htm#FilterExportSameFile - Create a Query and Export multiple "filtered" versions of a Query (based on data in another table) to separate Worksheets within one EXCEL file via TransferSpreadsheet (VBA)
http://www.accessmvp.com/KDSnell/EXCEL_Export.htm#WriteRstFile - Write Data From a Recordset into an EXCEL Worksheet using Automation (VBA)
http://www.accessmvp.com/KDSnell/EXCEL_Export.htm#ExpBrowseFile - Browse to a single EXCEL File and Export Data to that EXCEL File via TransferSpreadsheet (VBA)
http://www.accessmvp.com/KDSnell/EXCEL_Export.htm#ExpBrowseFolder - Browse to a single Folder and Export Data to a New EXCEL File in that Folder via TransferSpreadsheet (VBA)
http://www.accessmvp.com/KDSnell/EXCEL_Export.htm#ExpRange - Using the Range Argument of TransferSpreadsheet when Exporting Data to an EXCEL File (VBA)
------------- Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/ - http://www.accessmvp.com/KDSnell/
|