ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Hyperlink problem (https://www.excelbanter.com/excel-programming/297605-hyperlink-problem.html)

xnman

Hyperlink problem
 
I have a column of cells that I want to put hyperlinks in.
I came up witht the following
I will use a different name each time and the name is the name of the
file in the directory.

newlink1 = "D:/Data/People/Problems/"
fname = "Name1.doc"
Cells(rowctr, 11).Hyperlinks(1).Address = newlink1 + fname

But for some reason, which I have not been able to see, the new
hyperlink will not work.

Can someone help?

Thanks in advance.
xnman



All times are GMT +1. The time now is 09:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com