My hyperlink is not working i humbly request u to help

**catchnanan** · 08-09-2013, 01:20 PM

Hai my dear friends

i need a help ...i have various path names in my first 3 columns
for example my first column goes like this with various files like excell,word,jpg, sometimes even folder,
what i wnt is when i click any of them it should open

D:\EXCELL\nana.txt
D:\EXCELL\srini1.jpg
D:\EXCELL\srini2.xls
D:\EXCELL\expenses.doc
D:\EXCELL\seenivas
i made all hyperlinks using the following codes
but the problem is when i tried to open this links it come as" cannot open the specified file"

i tried for hours with various options but no use plz kindly help me

Please Login or Register  to view this content.

**martindwilson** · 08-10-2013, 06:15 AM

that works fine for me. have you tried saving the workbook and trying again?
i notice you have misspelled excel ,is that deliberate? and is your folder named the same?

**catchnanan** · 08-10-2013, 02:50 PM

Hai Martin thank you very much for your reply ...actually my link addresses in the columns will vary each time because the link is made up of formula
by taking input from sheet2 ...so each time the user will change the input in sheet2
the thing is each time when it is changed ,the link will change ,again the macro has to be run then only the link will work
this i found out after long work out