Output filtered report to excel file

polina

Registered User.
Local time
Today, 17:21
Joined
Aug 21, 2002
Messages
100
Hi

Is it possible to first apply the filter to the report and then output the report to the excel file?


With this code I just open the report applying the criteria:
DoCmd.OpenReport "WbtReport", acViewPreview, , "[AssetStatus]='active'"

Can I actually send that filtered report to excel not even opening the report?

Thanks
 

Users who are viewing this thread

Back
Top Bottom