Transfer data from multiple workbooks into Master workbook in SharePoint

I am trying to run in a macro in a SharePoint excel document that copies values in standardised timesheets and pastes them into a master file in SharePoint.

The code below works in my local drive but not when I export the master file in SharePoint and run it from there.

Can someone please help with amending the code below so that it works in SharePoint please:

Please Login or Register  to view this content.

When I currently run this macro in SharePoint all I get is the "Process is Complete" message without anything actually happening in the Zmaster file.

Your help is appreciated

Thanks

Code Tags Added
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 at http://www.excelforum.com/forum-rule...rum-rules.html



(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)