In order to download an excel file saved through Box, you need to click the link, sign on with username and pw and in my company also a push message to your cell phone. After installation of Box for Office after you open the file once there is a shortcut saved under Recent Files. If you click the hyperlink created under Recent Files, you can download the file without the credentials. I would like to open the file through the hyperlink, copy and paste what I need and close the file through VBA but I cannot figure out how to get the address behind the shortcut hyperlink. Right click is disabled. Any one had any luck with this?