By using wcxd.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

60 Things That Excel Can Do

Feature 44 - Find Data

I developed an VBA application that took input a sheet of two columns containing

Table name

Field name

The Sheet had over 6,000 rows.

I wrote code to search the entire system of data stored in a network directory for each of thousands of files (reports) which had an occurrence of the table and field.

The output was:

Report name (file name)

each column with table/field that matched