ComatePlus Excel Autofilter Question

Just starting out? Need help? Post your questions and find answers here.
pbnubee
New User
New User
Posts: 1
Joined: Fri Feb 12, 2021 4:54 pm

ComatePlus Excel Autofilter Question

Post by pbnubee »

I am trying to process an Excel Workbook (created by another program) with Purebasic ComatePlus. I have not been able to determine how to remove the "autofilters" which are set on each worksheet. I have tried variants of the following without any success. Any help? Thanks!

Code: Select all

			
ExcelObject\Invoke("Worksheets('Sheet1')\Select")
ExcelObject\SetProperty("Selection\AutoFilterMode = False")