I'm 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?
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?
