Hi -

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

OpenCurrentDatabase ("urizen.mdb")
DoCmd.OpenReport "Rpt1", 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:

DoCmd.OutputTo acOutputReport, "Rpt1", acFormatRTF, "c:\temp\Rpt1.rtf"

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

Thanks.

You will have more luck getting this answer from the Access newsgroup
--
- K Dales


"LHaro" wrote:

Hi -

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

OpenCurrentDatabase ("urizen.mdb")
DoCmd.OpenReport "Rpt1", 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:

DoCmd.OutputTo acOutputReport, "Rpt1", acFormatRTF, "c:\temp\Rpt1.rtf"

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

Thanks.