Add Hyperlink to existing Code

**stojko89** · 10-20-2011, 01:11 AM

Hi

I'm using this code:

HTML Code:

And it already makes an Hyperlink in Colum A to the sheet that it makes.
But I'm trying to put a code in here so when it makes the new sheet and the hyperlink it also makes a hyperlink in Colum L that would have the same name as the hyperlink in Colum A just .pdf attached to it and would be a hyperlink to a .pdf file.

Like this:

Row 2: Colum A= 0001-2011; Colum L=0001-2011.pdf
Row 3: Colum A= 0002-2011; Colum L=0002-2011.pdf

The hyperlinks in Colum L should be connected to \Naročila\target.value.pdf

Help Please.

**stojko89** · 10-20-2011, 05:30 AM

Hi so I'm tryn this code now for the add.hyperlinks:

HTML Code:

It makes the hyperlink
You can press it but it says unable to open file.
When I go check if the hyperlink is directed to the right file I see it's like this:
\Naročila\#Target.Value.pdf

So what can I use so the makro will search for the target.value of the selected cell plus adding the .pdf extention at the end so it finds this:
Cell A35 = 00037-2011 and this is the selected cell.
so the hyperlink direction should look like this:
\Naročila\00037-2011.pdf

Please help

**stojko89** · 10-20-2011, 06:48 AM

So nevermind...After a few hours of searching on the forum I found an answer that helped me

In case anyone will have the same problem or a problem like this.
I'm using this code that searches for the target name with .pdf extention and it makes the hyperlink:

HTML Code:

You just have to play with the code a little to make it work in your workbook for the stuff you want.