Hi -

If someone can help me with this, I would really appreciate it. What I want
to do is export an access report to my c drive that has filters from excel.
My original code simply opens the report and prints it out e.g.

OA.OpenCurrentDatabase ("urizen.mdb")
OA.DoCmd.OpenReport "TherapistRpt", acViewNormal, "Floor='10'"

but now i would like to just export it without printing it out, which i can
do with the following line of code:

OA.DoCmd.OutputTo acOutputReport, "Rpt2", acFormatRTF, "c:\temp\z.rtf"

is there any way i can specify the filter using this method?

Thanks.