Correct link to local folder in excel

Question

Level 1

0 points

Correct link to local folder in excel

I have a datebase of materials in excel document with cells that have paths to folders where the materials are stored

I want to link my local folders from my network to these certain cells in Excel so that my friends both from PC and Mac could quickly access them.

Unfortunately, when I add folder address from my local network that starts from smb:// - the system doesn't understand that and turns it to local.

What is the right thing to do?

MacBook Pro, OS X Mountain Lion (10.8.4)

Posted on Aug 7, 2013 12:47 AM

Reply

Answer 1

h.gosker

Level 1

0 points

Jan 8, 2014 7:58 AM in response to macuache

As far as I know it is not possible directly. I made a workaround though which implies making a webpage that does the trick (you'd need access to some webserver).

Make a simple webpage, eg http://www.yourdomain.com/excel2path.htm with this source code:

<html>

var OpenPath=parent.location.search.substring(1) // retrieves smb-path from URL (all after the ?-mark)
location.href=OpenPath

</script>
</head>

<body>

</body>

</html>

Then in excel the formula for the hyperlink should be something like:

=HYPERLINK("http://www.yourdomain.com/excel2path.htm?smb://serverx/folderx/filex", "friendly name to click on")

(with the CONCATENATE function you could dynamically build the smb-path)

Done. If you now click on the hyperlink in excel, the webpage should load which takes the smb-path from the URL and automatically redirects to that path...

Reply