Excel rollup macro works on file share but not in SharePoint document library

I have a macro which combines similarly formatted data from multiple workbooks into a rollup workbook when all files live in the same folder. It works fine on a file share but doesn’t work when the files are in a folder on a SharePoint site. I tried changing the sPath to the url of the SharePoint folder but the macro threw an error.

The code below works when the files are in a file share.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thank you for any assisstance.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(I have added them for you. Please read our rules and adhere to them in the future.

Thread posted in CS subforum hence closed.