Obtaining hyperlink address after installing Box for Office
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?