Aug 12 2020 12:32 PM
I've had a strange request from one of my end users. We have an Incident Investigation Form that's been built in Excel. They would like to add a button to the form to link out to another file that would have notes from the employee that was hurt.
I'm pretty sure I can get a shape/button to the point where the hyperlink will take me to the correct SharePoint folder but what I don't know how to do is to capture the exact file and have it save as a link. So that when the file is saved, it saves that exact link and not just going back to the general folder when the button/shape is clicked on.
Any thoughts on how I might do this? I'm thinking maybe with VBA but I'm not a programmer so I'd need help.
Thank you
Kendra
Aug 12 2020 06:12 PM
Have you tried to check the detail of the file location on the sharepoint by right click on the file and click on properties, then click on security tab, then copy the address beside the object name?
Cheers