Hyperlink Problem

[JanF]

Hi,

Here is my code I couldn't get it working

Please Login or Register  to view this content.

How to put full path to cell like hyperlink ?

Thanks,
Jan.

[JanF]

Sorry for this.
I have edited post.

Thanks Fotis1991...

[JanF]

Come on ExcelMasters, really need your help...

[Leith Ross]

Hello JanF,

This will do it...

Please Login or Register  to view this content.

[Xx7]

Try this...

Please Login or Register  to view this content.

[JanF]

Thanks guys, it works fine.

I have another question, it's about hyperlink again so I don't want to open new thread - I will post here

I have code that converts text to hyperlink

Please Login or Register  to view this content.

This code works fine but it add file:/// to my file path.
How to remove this file:/// because hyperlink will not work when path is like \\server_name\folder\file.pdf

\\server_name\folder\file.pdf this work
file:///\\server_name\folder\file.pdf this doesn't work

Thanks

[JanF]

Nobody?

my filepath looks like \\server_name\folder\file.pdf because I'm running on local server in my company.
and when this code add file:/// to filepath it looks like this file:///\\server_name\folder\file.pdf and this doesn't working.

Is there any way to remove file:/// from link or something else?

Thanks again guys...

[Leith Ross]

Hello JanF,

What are in the cells when you run the code?

[JanF]

When I run the code from Leith Ross is: \\SrvVSQL65\Kor_rezerva\1_TEH\.TEHNIČKA OPERATIVA\1 POSLOVI OPERATIVE\Priključci\mapa\P 69-2014.pdf (hyperlink)
When I position cursor on hyperlink and wait for info to show then it says: file:///\\SrvVSQL65\Kor_rezerva\1_TEH\.TEHNIČKA OPERATIVA\1 POSLOVI OPERATIVE\Priključci\mapa\P 69-2014.pdf (this hyperlink is NOT working)

Hyperlink from cell is automatically stored in some file.txt like text witch is: \\SrvVSQL65\Kor_rezerva\1_TEH\.TEHNIČKA OPERATIVA\1 POSLOVI OPERATIVE\Priključci\mapa\P 69-2014.pdf
When I open other workbook that reads text from file.txt and converts it to hyperlinks using code that I posted in cell is \\SrvVSQL65\Kor_rezerva\1_TEH\.TEHNIČKA OPERATIVA\1 POSLOVI OPERATIVE\Priključci\mapa\P 69-2014.pdf
but again when I position cursor on hyperlink and wait for info to show it says: file:///\\SrvVSQL65\Kor_rezerva\1_TEH\.TEHNIČKA OPERATIVA\1 POSLOVI OPERATIVE\Priključci\mapa\P 69-2014.pdf

This is a little bit confusing

I think that hyperlink like: \\SrvVSQL65\Kor_rezerva\1_TEH\.TEHNIČKA OPERATIVA\1 POSLOVI OPERATIVE\Priključci\mapa\P 69-2014.pdf
will work but when the system adds file:/// to this path is NOT working (it says cannot open specified file)

[JanF]

problem solved,
thanks for help.

folder name was wrong
my mistake...