Folder Paths HyperLink

[lcorcoran]

Hi all,

I'm getting a list of folder Paths using PowerQuery, when I send to table to excel, I want the paths to be a clickable link to open the folder.
I tried using this formula "=HyperLink([@[Folder Path]],[@Name])" but all it's returning is "#REF!" error.
Any help would be much appreciated

 

[jdellasala]

You can't do that as you've seen. Your best bet is to have a macro that will open a folder in the active cell:

Sub OpenFolder()

Dim strFolder As String
strFolder = ActiveCell.Value

Shell "explorer.exe " & strFolder, vbNormalFocus

End Sub

In testing it I found that it worked with or without a trailing backslash.
Know that I am not a fan of VBA, but this is an instance where it is needed.

 

[lcorcoran]

You can't do that as you've seen. Your best bet is to have a macro that will open a folder in the active cell:

Sub OpenFolder()

Dim strFolder As String
strFolder = ActiveCell.Value

Shell "explorer.exe " & strFolder, vbNormalFocus

End Sub

In testing it I found that it worked with or without a trailing backslash.
Know that I am not a fan of VBA, but this is an instance where it is needed.

Hi Thanks for the reply, I was going down the road of the VBA, but I tried it on a second workbook and it worked for me in that file, not sure why I was getting the error in the first file, the formula is the same