Trying to create a dynamic hyperlink

=HYPERLINK(c:UserstminnickDesktop("#FileName",A159)_EmploymentAgreement.pdf)

This is the link that retus an error message. the ("#FileName",A159) formula is intended to pull the text in A159, which is the first part of the full filename. There are 168 records.

Thank you.

Recent Questions...