Hello,
My company moved everything onto sharepoint. I have a financial model with numerous hyperlinks embedded that linked to various types of backup files (excel, PDF, email etc etc). I have a macro that creates these links using the sharepoint locations (I opened the main model workbook in sharepoint then went to edit hyperlink to figure out the location where the backup files are saved on sharepoint, then copy that address to the macro), but the links don't work although the text is identical to the one if I created by using edit hyperlinks directly. Does anyone know why and how can I make it work?
basically the below shows the two hyperlinks, the first one is done by using Edit Hyperlinks (and this one works), and the second one is done by just copying the text above (and this one doesn't work though it is identical).
'https://alectra.sharepoint.com/sites/EnergySolutions/Projects/Financial%20Analysis%20and%20Investments/Budgets/Alectra%20Energy%20Services%20Inc/Submetering/Company_31_2021_Budget-%20Draft%205%2006.03.2020.xlsm[/url]
'https://alectra.sharepoint.com/sites/EnergySolutions/Projects/Financial%20Analysis%20and%20Investments/Budgets/Alectra%20Energy%20Services%20Inc/Submetering/Company_31_2021_Budget-%20Draft%205%2006.03.2020.xlsm[/url]
thanks so much
Bookmarks