title: Run macro for all Workbooks in a Sharepoint folder
body: <p>I have written a macro to produce a report, which works perfectly but I need to run it for all files saved in a SharePoint folder. Currently this involves opening each workbook (aproximately 30), running the macro and then saving-as back to the folder with &quot;summary&quot; appended to the file name.</p>
  <p>Is there a way of running my macro for all Workbooks in the Sharepoint folder and saving to the same location? I have Googled this problem extensively but could only find solutions that work with mapped drives, rather than SharePoint https:// links.</p>
  <p>Any pointers or advice would be greatly appreciated.</p>
  <p>Many thanks,</p>
  <p>TE</p>