Hi,
I've to bring auto filter in my excel 2007 report which is scheduled on daily basis. Below code works fine for Excel 2003 but not working in 2007.
Please help!!!!!!!!!

 
DEFINE FILE CAR
 AUTOFILTER/A700 = '<tr>'
                 | '<td style="white-space:normal;mso-pattern:auto none;font-family:arial;color:white;font-size:12px;font-weight:700;text-align:center;background-color:rgb(79,129,189);" x:autofilter="all" x:autofilterrange="$A$2:$C$2">Country<br></td>'
                 | '<td style="white-space:normal;mso-pattern:auto none;font-family:arial;color:white;font-size:12px;font-weight:700;text-align:center;background-color:rgb(79,129,189);" x:autofilter="all">Car<br></td>'
                 | '<td style="white-space:normal;mso-pattern:auto none;font-family:arial;color:white;font-size:12px;font-weight:700;text-align:center;background-color:rgb(79,129,189);" x:autofilter="all">Model<br></td>'
                 | '</tr>' ;
END
-*
TABLE FILE CAR
HEADING
 "Report Heading<AUTOFILTER"
 PRINT
  COUNTRY AS ''
  CAR AS ''
  MODEL AS ''
 ON TABLE SET STYLE *
  TYPE=REPORT, GRID=ON, FONT='ARIAL NARROW', SIZE=10, COLOR='BLACK', STYLE=NORMAL,
       WRAP=ON, SQUEEZE=ON, TITLETEXT='Car Info', $
  TYPE=HEADING, SIZE=13, STYLE=BOLD, COLOR=WHITE, BACKCOLOR=RGB(165 165 165), JUSTIFY=CENTER, $
 ENDSTYLE
 ON TABLE PCHOLD FORMAT EXL07
END

This message has been edited. Last edited by: <Kathryn Henning>,

Try "EXL2K" instead of "EXL07".

"EXL07" does not work at all for me, I get (in 7.6.11):

   0 ERROR AT OR NEAR LINE     21  IN PROCEDURE ADHOCRQ FOCEXEC *
 (FOC160) THE OPTION AFTER THE WORD 'FORMAT' IS INVALID: EXL07
 BYPASSING TO END OF COMMAND
 (FOC009) INCOMPLETE REQUEST STATEMENT
 (FOC009) INCOMPLETE REQUEST STATEMENT

EXL2K created a web archive, EXL07 creates an Excle 2007 document.

Ths techique will only work on EXL2K