Passing data to Excel via hyperlink RRS feed

  • Question

  • My excel app opens up to a userform - from that userform, the user can do several functions within the application from entering new data, editing existing data, and reviewing/approving the cases.

    When a case is submitted for approval, the application sends an email with a hyperlink to a predetermined distribution group by sending an Outlook email containing a hyperlink to the application. This part is easy and completed.

    What I'd like to do is embed the case number into the hyperlink, which I believe I've also figured out how to do. What I want then is that when the hyperlink is used to open the app, it passes that case number back to Excel, so that I can grab it and use it within the reopened app. This is the part I'm struggling to find any solutions to.

    Make sense?



    Thursday, January 17, 2019 5:24 PM