RE: view a .pdf invoice file from their customer record in a userform textbox...

[chazrab]

Is it possible to open and view a pdf file (icon or hyperlink) in a userform textbox for that particular customer record ? There are
many customer records each with a pdf invoice. I'd like to be able to view any pdf by clicking on a textbox icon or link for that customer (textbox in red frame). I can access any website using

 ActiveWorkbook.FollowHyperlink Address:="https://www.nfcu.org", NewWindow:=True

but that's a website. If there is no way to open a specfic .pdf from clicking a textbox for that customer, then is there a way to refer to a pdf on
This PC using a hyperlink as in the above code ?
Thanks for anyone's help.
cr

 

[John_w]

Simply:

    ActiveWorkbook.FollowHyperlink "C:\path\to\Invoice 123.pdf"

change the path and file name as required.

 

[chazrab]

Works great - how simple. Thanks, John.
cr