myexcellent123, are these workbooks hosted on a teamsite in SharePoint, or do you have access to a folder which contains all these workbooks? If you only have the SharePoint links, and not a folder path, then can you post the code you already have.