Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
Keywords: Excel Filtering Function
When I scan the filtered table, the program seems not to take the filter in account and gives me a complete list and not a filtered list of applications.
; use ADO to Filter out Excel Data ; Stan Littlefield - September 4, 2002 cXLS = StrCat( DirGet(), "test.xls" ) If ! FileExist( cXLS ) Then Exit cConn = "DRIVER={Microsoft Excel Driver (*.xls)};DriverId=790;ReadOnly=True;DBQ=%cXLS%" DB = ObjectOpen( "ADODB.Connection" ) RS = ObjectOpen( "ADODB.Recordset" ) DB.Open( cConn ) RS.Open( "SELECT * FROM [PC$] WHERE [Applications] LIKE 'Acrobat%%'", DB, 3, 3, 1 ) fld1 = RS.Fields("PC Names") fld2 = RS.Fields("Applications") While ! RS.Eof() Message(fld2.Value,fld1.Value) RS.MoveNext() EndWhile RS.Close() ObjectClose( RS ) DB.Close() ObjectClose( DB ) Exit
Article ID: W15253
File Created: 2002:09:05:13:50:50
Last Updated: 2002:09:05:13:50:50