writing an excel application that needs to connect to a sharepoint server & look for other excel books with a certain string in the name. Matching books will then be opened, and data will be copied into the application.

I've figured out how to open a workbook from sharepoint & extract data from it, however, I can't figure out how to read through the directory & look for files that match the string.

Does anyone know a function I could use similar to DIR?