Forum Discussion
Referencing a Hyperlink without Referencing the Source
I'm working on a side project for work that will pull a .PDF claim form, attach to an email, and send it to the customer's email address. I have it currently to where it pulls the .pdf from the site directly and attaches it. For example, the hyperlink leads to http://www.worksite.com/ClaimForm.pdf* and that's where I'm pulling the file from directly. But if I code this into a UserForm and later on the file name changes, it becomes useless. Is there a way to reference the hyperlink itself instead of the source? i.e. The hyperlink says "Claim Form" and I want it to reference that link always instead of the full address of the form: http://www.worksite.com/ClaimForm.pdf*. Is it even possible?
* these aren't real links. I can find one to use if needed.