View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Héctor Miguel Héctor Miguel is offline
external usenet poster
 
Posts: 434
Default hyperlink to a folder?

hi, anonymous !

Excel hyperlinks are presumed to be aimed at other Excel files.
How can I create a hyperlink in a cell, that takes the user to a project folder
(so that clicking the link opens the folder in a standard Windows Explorer window)?


try with *a project folder* path in *a cell*
- ie. A1: c:\documents and settings\my profile\special project folder

and use hyperlink worksheet function in some other cell
- ie. =hyperlink("file:////"&a1,"Jump to folder in A1")

hth,
hector.