ADP filtered data export to Excel

[effendi]

In an access data project, user has select access on specific views; insert, update, delete are only through stored procedures. When viewing a particuar form, user can filter and sort as desired. I want to programmatically export the data (ie on the click of a cmd button) in the form, as filtered and sorted, to text or excel file. Seems like it should be easy, but I'm stuck.

Transferspreadsheet expects a table or view to be defined. Since the filtering is done by the user dynamically that table or view would not exist. How to solve this problem...