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.