Need to Consolidate multiple workbooks in to a Master Workbook w/ files on SharePoint

Thank you JBeaucaire from your post.

After copy-pasting the URL into the "sharePATH", the excel file name between the quotes "" and running the script the following error appears:
"Cannot perform this operation. The file has been deleted or someone else has it checked out"

Do you know how to fix this?
The file is stored in a SharePoint 2007 shared document (sub)folder, is still open (not checked out) and is accessible to everyone...