Help with Filtering rows in Excel via VFP

[Goofus828]

I have a spreadsheet that I populate via VFP9. When I am in the spreadsheet sometimes I filter the table and forget to turn the filter off. When I add data via VFP, sometimes the data insertion gets 'misplaced' because of the filter. I know how to turn the filter off programmatically but I am having problems turning it on to filter a specific date and keep the blank rows in the table.

Here is the VBA line of code that I created via a macro:

This sets the filter to only show blank rows and the month of November 2021.

ActiveSheet.ListObjects("Inspections").Range.AutoFilter Field:=2, Criteria1:=Array("="), Operator:=xlFilterValues, Criteria2:=Array(1, "11/29/2021")

This only shows blank rows.

oExcel.ActiveSheet.ListObjects("inspections").Range.AutoFilter( 2,"=")

I do not know how to handle the criteria 2 in VFP

Criteria2:=Array(1, "11/29/2021")

Any help would be appreciated.
Josh

 

[Goofus828]

Bueller…? Bueller??

 

[Rick C. Hodgin]

I'm not sure how to pass in parameters as arrays, but here's an example that might get you part way there:
VFP mass-updating with arrays

It might be as simple as using @arrayName to pass it by reference.

--
Rick C. Hodgin