Excel automation - Filter AutoFilter

fmhigue

Hi there:

Got a question. Have anyone of you created a function to use Filter - Auto Filter on an excel spreadsheet?

Thank you in advance

Belias

Try to register a macro in excel, active the filters and then edit the macro...
you will discorver that the instruction is "selection.Autofilter"....try to reproduce it in NAV...
you can do this trick for nearly everything you can do in excel

DaveT

If you look at the globals on table 370 Excel buffer you will see different automations declared. The worksheet has a property for auto filtering.


[BOOL AutoFilterMode :=] XlWrkSht.AutoFilterMode([BOOL AutoFilterMode])

haven't tried it but looks like what you need.