Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Selecting for export to Excel - only selected records
- Thread starter actdjohng
- Start date
Hi actdjohng
I assume you are trying to export from a form - and this exports all records (no way to change this as far as i know).
However, using the transferspread method - you could use a query to do that for you.
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryYourQuery", "C:\YourFileName.xls"
Code or Macro - your choice.
Stew
I assume you are trying to export from a form - and this exports all records (no way to change this as far as i know).
However, using the transferspread method - you could use a query to do that for you.
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryYourQuery", "C:\YourFileName.xls"
Code or Macro - your choice.
Stew
- Status
Similar threads
- Locked
- Question
- Locked
- Question