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 "summary" appended to the file name.
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.
Any pointers or advice would be greatly appreciated.
Many thanks,
TE