I am trying to use the following to open a specific file (Test SharePoint File.xlsm) from a SharePoint folder called 'Test' 
Please Login or Register  to view this content.
I get a 1004 error stating 'Sorry, we couldn't find http://owner.sharepoint.com/Test/Tes...rePoint%20File. Is it possible it was moved, renamed or deleted?'

The file does exist and I can open it manually.

also I want to open the file in desktop Excel and not in the browser if possible.


TIA