We help IT Professionals succeed at work.

Use Excel hyperlink command to create a link to a file using both file location and active sheet cell value

Medium Priority
33 Views
Last Modified: 2020-03-06
Hi.  I'm trying to create a hyperlink within an excel worksheet that first adds the file location of a saved document and then adds the file name from a cell in the active worksheet.  The intent is to display some of the info in the worksheet but user can click the hyperlink to open the corresponding document to view in more detail.  

File location would be a network shared location "x:\Foldera\Folderb\"
file name would exist in cell AA4 in the active worksheet.  

I got closest using this but document would not open:
=HYPERLINK("x:\Foldera\Folderb\"&AA4)
Comment
Watch Question

CERTIFIED EXPERT
Commented:
Your formula is correct and should work. What I would do is in an adjacent cell enter ctrl+K. This will bring up the hyperlink dialog box. Navigate to the file you want to open and select OK. Compare the link to the one in your formula. It could be something simple like a missed space.
Paul

Author

Commented:
Thanks for that tip.  Had no idea there was a key command to get into the dialog box.  Turns out i was just missing the file extension.  All fixed.  Cheers!
CERTIFIED EXPERT

Commented:
You're welcome. Glad to help out!