X
xnman
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
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