Trying to get XL file from Sharepoint in Edge

[EdNerd]

Using VBA in XL365 (Win 10), I can open an XL file that is uploaded to our corporate Sharepoint site. I am using:

CreateObject("Shell.Application").ShellExecute str

I am running into two issues:
(A) After opening, the Sharepoint site gets the focus, and the VBA code stops. Can I put something in there to return focus back to the code to continue the routine?
(B) When the XL file opens, it's still in the Edge browser. If I stop at loading the page that hold the file, is there a method to use to download the file? If not, can I use some kind of SaveAs method to get the file?

Thanks!
Ed

 

[EdNerd]

Wanted to expound - too late to edit:

"str" is a string variable containing the full URL of the Sharepoint site, including the XL file name. If I include the file name, the file opens. If I take out the file name, the Sharepoint page opens, but then I need to know how to attach the file and download it.

The last part of the string is "action=default&mobileredirect=true". Do I need a different "action" to accomplish what I want?