VBA - Adding Hyper link to cell doesn't work

B

Barbarte

Board Regular
Joined
Dec 13, 2006
Messages
125
Hi All,

I have a piece of code that adds a hyperlink to a cell:

Code: 
Cells(rowno1, 7).Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:=Link & CompanyName & " - " & 
ProjectTitle & "\" & TrackTitle & " - " & Publisher & ".xlsm", TextToDisplay:=Publisher

In the above "Publisher" is a previously set name.
It appears to work, however when I click on the link I get the message "cannot open the specified file"
when I edit the hyperlink it says:
"Publisher%20Sync%20Requests\Avalon%20Films%20-%20Between%20the%20Canals\JOHNNY%20MCGORY%20%20%20-%20ST-JOHN%20PETE%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20.xlsm"

I manually set the hyperlink and it now says:

"Publisher%20Sync%20Requests\Avalon%20Films%20-%20Between%20the%20Canals\JOHNNY%20MCGORY%20%20%20-%20ST-JOHN%20PETE%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%202.xlsm"

which as far as I can see is exactly the same, except now the hyperlink works.
Anyone any Ideas what I'm doing wrong?

Best wishes,

Paul.
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

K
  • Question
how to make hyper link Button ?? when i click down in cell with show "Add New " Button (button is hyperlink)
Replies
0
Views
439
krunal123
K
F
  • Question
VBA: adding link anchor from the function
Replies
4
Views
964
FlexMind
F
P
  • Question
[VBA] Create Hyperlink to latest worksheet in Workbook
Replies
1
Views
524
ravishankar
R
C
  • Question
Hyper Link
Replies
1
Views
372
ColeGwoz
C
C
  • Question
Adding VBA hyperlink to a cell on another sheet
Replies
1
Views
3K
chickenchester
C

Forum statistics

Threads
1,215,734
Messages
6,126,545
Members
449,317
Latest member
chingiloum

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top