What is the syntax to open a folder through a hyperlink?

Dim sXLFile As String
sFolder = “<folder’s filepath>
ActiveWorkbook.FollowHyperlink Address :=sFolder, NewWindow:=true

To learn how to find a folder’s filepath, click here.

‘example that opens the Downloads window upon clicking link
Dim sXLFile As String
sFolder = “C:\Users\jwatson\Downloads”
ActiveWorkbook.FollowHyperlink Address :=sFolder, NewWindow:=true
Advertisements