export to excel

[chungtinhlak]

can someonehelp me with a code on a command button to export current report view to excel format?

thanks

[CreganTur]

Take a look at the TransferSpreadsheet method. TransferSpreadsheet outputs a table or Query- so you'll need your query to pull the same records as your report.