Kbase P98486: How to turn on the MS Excel Autofilter from Progress using ActiveX Automation
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/7/2004 |
|
Status: Unverified
GOAL:
How to turn on the MS Excel Autofilter from Progress using ActiveX Automation
GOAL:
How to add the Autofilter arrow in the column labels of a MS Excel document
GOAL:
How to call the MS Excel Autofilter method from Progress
FIX:
Call the AutoFilter() method with 5 arguments, 2 optional:
[ <anytype>-Var = ] <com-handle>: AutoFilter (
<anytype>-Field,
<anytype>-Criteria1,
Integer-Operator,
<anytype>-Criteria2,
<anytype>-VisibleDropDown ).
In this sample, it is presumed that the first line contains the column labels:
DEFINE VARIABLE chExcel AS COM-HANDLE NO-UNDO.
CREATE "Excel.Application" chExcel .
/* ... */
chExcel:workbooks(1):worksheets(1):range("1:1"):AutoFilter(,,,,).